| From: | Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Statement Level Deferred Triggers |
| Date: | 2009-10-26 02:11:23 |
| Message-ID: | 20091026110652.AA8A.52131E4D@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andres Freund <andres(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-10-26 02:34:02 | Endgame for all those SELECT FOR UPDATE changes: fix plan node order |
| Previous Message | 노홍찬 | 2009-10-26 01:45:25 | Re: a question about relkind of RelationData handed over to heap_update function |