Andres Freund wrote:
> I would like to hear some opinions before starting to take a stab at
> implementing $subject.
+1 to support it.
I'm using deferred trigger to emulate on-commit trigger,
but official support is infinitely better.
UPDATE pg_catalog.pg_trigger
SET tgdeferrable
On Fri, Oct 23, 2009 at 7:29 PM, Andres Freund wrote:
> Hi all,
>
> I would like to hear some opinions before starting to take a stab at
> implementing $subject.
> My current use case is updating materialized views at the end of the
> transaction so that they appear consistent to the outside.
> Up
Hi all,
I would like to hear some opinions before starting to take a stab at
implementing $subject.
My current use case is updating materialized views at the end of the
transaction so that they appear consistent to the outside.
Updating them on every row changed is far too expensive - so every c