Re: Statement Level Deferred Triggers - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: Statement Level Deferred Triggers
Date
Msg-id 20091026110652.AA8A.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Statement Level Deferred Triggers  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> 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 = true, tginitdeferred = true    WHERE tgrelid =
'atcommit_tbl'::regclass     AND tgname = 'atcommit';
 

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: 노홍찬
Date:
Subject: Re: a question about relkind of RelationData handed over to heap_update function
Next
From: Tom Lane
Date:
Subject: Endgame for all those SELECT FOR UPDATE changes: fix plan node order