Postgres Pro
Downloads
Home   >   mailing lists

Re: deferred triggers? - Mailing list pgsql-general

From Tom Lane
Subject Re: deferred triggers?
Date
Msg-id 20895.1224266353@sss.pgh.pa.us
Whole thread Raw
In response to deferred triggers?  (Ben <bench@silentmedia.com>)
Responses Re: deferred triggers?  (Ben <bench@silentmedia.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: schema and roles
Next
From: Tom Lane
Date:
Subject: Re: Drop database / database in use question