Re: Add Foreign Keys To Table

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Add Foreign Keys To Table
Date: 2011-07-07 18:55:25
Message-ID: alpine.LNX.2.00.1107071154260.20399@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2011-07-07 19:07:46 Re: Add Foreign Keys To Table
Previous Message French, Martin 2011-07-07 18:54:08 Re: [PERFORM] DELETE taking too much memory