Re: Add Foreign Keys To Table - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Add Foreign Keys To Table
Date
Msg-id 201107071207.46656.ahodgson@simkin.ca
Whole thread Raw
In response to Re: Add Foreign Keys To Table  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Add Foreign Keys To Table  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On July 7, 2011 11:55:25 AM Rich Shepard wrote:
> On Thu, 7 Jul 2011, Alan Hodgson wrote:
> > You need a unique index on station_type.sta_type
>
> Alan,
>
>    station_type(sta_type) is part of a composite primary key. Doesn't
> primary key automatically imply unique and not null?

It implies the composite is unique. Not sta_type.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Add Foreign Keys To Table
Next
From: Rich Shepard
Date:
Subject: Re: Add Foreign Keys To Table