Deferred uniqueness versus foreign keys

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)googlemail(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Deferred uniqueness versus foreign keys
Date: 2009-07-28 20:08:58
Message-ID: 7260.1248811738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

[sigh, forgot to cc hackers the first time ]

Foreign key behavior is only sane if the referenced column(s) are
unique. With the proposed patch, it is possible that the uniqueness
check on the referenced columns is deferred, which means it might not
occur till after an FK check does. Discuss.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-07-28 20:19:58 Re: xpath not a good replacement for xpath_string
Previous Message Kevin Grittner 2009-07-28 20:06:48 Re: xpath not a good replacement for xpath_string