Postgres Pro
Downloads
Home   >   mailing lists

Re: multi column foreign key for implicitly unique columns - Mailing list pgsql-sql

From Tom Lane
Subject Re: multi column foreign key for implicitly unique columns
Date
Msg-id 22808.1092842209@sss.pgh.pa.us
Whole thread Raw
In response to Re: multi column foreign key for implicitly unique columns  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: multi column foreign key for implicitly unique columns  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
Jan Wieck <JanWieck@Yahoo.com> writes:
> However, Bruce, this should be on the TODO list:
>      * Allow foreign key to reference a superset of the columns
>        covered by a unique constraint on the referenced table.

See the followup discussion as to why this is a bad idea.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL Challenge: Arbitrary Cross-tab
Next
From: Bruce Momjian
Date:
Subject: /contrib and win32