One more question: does the FK checker know to skip checking a constraint if the column in question did not change during an update?
That is, if I have a user table that references an owner_id in an owners table as a foreign key, but I update fields other than owner_id in the user table, will it still try to verify that owner_id is a valid value even though it did not change?
I'm using PG 7.4.
As of 7.4, yes the check is skipped.
Chris
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly