Hi, I have a trigger in my database that checks to see if there is another record in the table, and when there is if the type is correct. (if the first one is of type "parent", the other has to be of type "child").
When updating these records in a transaction, the trigger only works when I make it deferrable. I hacked this by updating pg_trigger and setting the column tgdeferrable to true. IS there a way to do this in SQL? I can only find documentation on setting a constraint to deferrable, but not on a trigger. TIA, Reinoud -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen [EMAIL PROTECTED] http://www.xs4all.nl/~reinoud __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster