Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Jul 2009 16:08:58 -0400
- Message-id: <7260.1248811738@sss.pgh.pa.us> <text/plain>
[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
- Follow-Ups:
- Re: Deferred uniqueness versus foreign keys
- From: Dean Rasheed
- Re: Deferred uniqueness versus foreign keys
- Prev by Date: Re: xpath not a good replacement for xpath_string
- Next by Date: Re: xpath not a good replacement for xpath_string
- Previous by thread: xpath not a good replacement for xpath_string
- Next by thread: Re: Deferred uniqueness versus foreign keys
- Indexes: