Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: Add Foreign Keys To Table
Date
Msg-id alpine.LNX.2.00.1107071154260.20399@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Add Foreign Keys To Table  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: Add Foreign Keys To Table
List pgsql-general
Tree view 
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?

Thanks,

Rich

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Add Foreign Keys To Table
Next
From: Alan Hodgson
Date:
Subject: Re: Add Foreign Keys To Table