Re: deferred foreign keys - Mailing list pgsql-performance

From Vivek Khera
Subject Re: deferred foreign keys
Date
Msg-id x73cb0c3ep.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to deferred foreign keys  (Vivek Khera <khera@kcilink.com>)
Responses Re: deferred foreign keys
List pgsql-performance
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@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Jonathan Gardner
Date:
Subject: DELETE ... WHERE ctid IN (...) vs. Iteration
Next
From: "cnliou"
Date:
Subject: pg_restore makes disk busy