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: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
