Re: Multiple keys?

From: Richard Poole <rp(at)guests(dot)deus(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Multiple keys?
Date: 2002-08-28 10:22:47
Message-ID: 20020828102247.GA23727@guests.deus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Casey Allen Shobe 2002-08-28 10:34:55 Re: Multiple keys?
Previous Message Andre Schubert 2002-08-28 08:38:02 Errors with pg_dump