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.

Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: [EMAIL PROTECTED]       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to