Postgres Pro
Downloads
Home   >   mailing lists

Deferred uniqueness versus foreign keys - Mailing list pgsql-hackers

From Tom Lane
Subject Deferred uniqueness versus foreign keys
Date
Msg-id 7260.1248811738@sss.pgh.pa.us
Whole thread Raw
Responses Re: Deferred uniqueness versus foreign keys  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
List pgsql-hackers
Tree view 
[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

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: xpath not a good replacement for xpath_string
Next
From: Andrew Dunstan
Date:
Subject: Re: xpath not a good replacement for xpath_string