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

From Rod Taylor
Subject Re: multi column foreign key for implicitly unique columns
Date
Msg-id 1092843903.32799.132.camel@jester
Whole thread Raw
In response to Re: multi column foreign key for implicitly unique columns  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
> 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.

It would probably be more beneficial to be able to create a unique
constraint without requiring the fields be indexed.

Gets rid of most of the overhead from double uniques.




pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: /contrib and win32
Next
From: Richard Huxton
Date:
Subject: Re: multi column foreign key for implicitly unique columns