Re: Statement Level Deferred Triggers

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: Statement Level Deferred Triggers
Дата
Msg-id 20091026110652.AA8A.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Statement Level Deferred Triggers  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: 노홍찬
Дата:
Сообщение: Re: a question about relkind of RelationData handed over to heap_update function
Следующее
От: Tom Lane
Дата:
Сообщение: Endgame for all those SELECT FOR UPDATE changes: fix plan node order