Postgres Pro
Downloads
Home   >   mailing lists

Thread: deferred triggers?

deferred triggers?

From
Ben
Date:
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.

Re: deferred triggers?

From
Tom Lane
Date:
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

Re: deferred triggers?

From
Ben
Date:
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
>