Re: [HACKERS] Statement Level Deferred Triggers

2009-10-25 Thread Itagaki Takahiro
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

Re: [HACKERS] Statement Level Deferred Triggers

2009-10-23 Thread Robert Haas
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

[HACKERS] Statement Level Deferred Triggers

2009-10-23 Thread Andres Freund
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