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.
Thanks.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/