Re: deferred foreign keys

>>>>> "CK" == Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:

>> One more question: does the FK checker know to skip checking a
>> constraint if the column in question did not change during an update?

CK> As of 7.4, yes the check is skipped.

Thanks. Then it sorta makes it moot for me to try deferred checks,
since the Pimary and Foreign keys never change once set. I wonder
what is making the transactions appear to run lockstep, then...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/