Re: Multiple keys? - Mailing list pgsql-admin

From Richard Poole
Subject Re: Multiple keys?
Date
Msg-id 20020828102247.GA23727@guests.deus.net
Whole thread Raw
In response to Multiple keys?  (Casey Allen Shobe <cshobe@secureworks.net>)
Responses Re: Multiple keys?  (Casey Allen Shobe <cshobe@secureworks.net>)
List pgsql-admin
On Wed, Aug 28, 2002 at 02:10:44AM -0400, Casey Allen Shobe wrote:
> In order to get the foreign key I want working, I had to have two unique
> references on the parent table, though the second covers two columns that are
> contained within the first.  Is this wise?  Is there a better way?

Your two-column constraint, the one you need to add to get your foreign
key working, implies your three-column one. So you can just get rid of
the three-column one.

Richard

pgsql-admin by date:

Previous
From: Andre Schubert
Date:
Subject: Errors with pg_dump
Next
From: Casey Allen Shobe
Date:
Subject: Re: Multiple keys?