Re: Dual Primary keys - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Dual Primary keys
Date
Msg-id 20040204153518.GA20727@wolff.to
Whole thread Raw
In response to Dual Primary keys  ("Bantamess" <bantamess@yahoo.co.uk>)
List pgsql-novice
On Wed, Feb 04, 2004 at 15:15:45 -0000,
  Bantamess <bantamess@yahoo.co.uk> wrote:
> Hello can any body tell me how to code a table with dual primary keys? The table 'borrower' has two PKs each one has
beenused in other tables within the same schema as single PKs 

Use UNIQUE and NOT NULL constraints on one of the two keys. In references
to that key, you will need to specify the column name as the default
column name is the primary key.

pgsql-novice by date:

Previous
From: "Bantamess"
Date:
Subject: Dual Primary keys
Next
From: Tom Lane
Date:
Subject: Re: Dual Primary keys