Обсуждение: deferred triggers?

In 8.3, is there any way I can have a trigger that fires at commit time,
much like deferred foreign keys? I suspect the answer is "no" but it would
be nice if I'm wrong.

Ben <bench@silentmedia.com> writes:
> In 8.3, is there any way I can have a trigger that fires at commit time,
> much like deferred foreign keys?

See CREATE CONSTRAINT TRIGGER ... same mechanism that FKs use ...

            regards, tom lane

Awesome!

On Fri, 17 Oct 2008, Tom Lane wrote:

> Ben <bench@silentmedia.com> writes:
>> In 8.3, is there any way I can have a trigger that fires at commit time,
>> much like deferred foreign keys?
>
> See CREATE CONSTRAINT TRIGGER ... same mechanism that FKs use ...
>
>             regards, tom lane
>