Re: deferred foreign keys - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: deferred foreign keys
Date
Msg-id 3FF4FA25.7050802@familyhealth.com.au
Whole thread Raw
In response to Re: deferred foreign keys  (Vivek Khera <khera@kcilink.com>)
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.

As of 7.4, yes the check is skipped.

Chris

pgsql-performance by date:

Previous
From: Chris Trawick
Date:
Subject: Re: "fun with multipart primary keys" hobby kit
Next
From: "D. Dante Lorenso"
Date:
Subject: Indexing a Boolean or Null column?