On Jun 8, 2006, at 15:38 , Albert Cervera Areny wrote:
However, I've realized that managing foreign keys with my own
PL/SQL or C function isn't possible as I need DEFERRED checks which
are
currently only available for foreign keys.
I don't know enough about your situation to be sure if this will work
or not, but perhaps you want to look at CREATE CONSTRAINT TRIGGER.
They're deferred to the end of the transaction.
http://www.postgresql.org/docs/8.1/interactive/sql-createconstraint.html
In the hope that this helps,
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
