Triggers for FK on Views - can they be made deferrable? - Mailing list pgsql-general

From ezra epstein
Subject Triggers for FK on Views - can they be made deferrable?
Date
Msg-id 1tScnbCMHJ9EX32iXTWc-w@speakeasy.net
Whole thread Raw
Responses Re: Triggers for FK on Views - can they be made deferrable?  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
I've got the case of a table which has unusual FK constraints.  I'm
implementing them as triggers against a view.  It all works, BUT I don't see
a way to make the triggers executed only on Commit -- i.e., I'd like the
same "deferrable" behavior that true FKs provide.  Does anyone know how to
do this?

Thanks,

Ezra E.



pgsql-general by date:

Previous
From: Mélanie Bergeron
Date:
Subject: automatic verifications
Next
From: "Kaushik Roy"
Date:
Subject: Regarding Start of postmaster