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 19:30:35
Message-ID: alpine.LNX.2.00.1107071228200.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:

> It implies the composite is unique. Not sta_type.

OK. Now I understand. How, then, do I add a unique constraint to each
component of the composite key so I can add them as foreign keys to the
station_information table? Or, is there another way to add those two columns
to station_information and then add the foreign key constraints?

Thanks for clarifying,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2011-07-07 19:44:48 Re: Add Foreign Keys To Table
Previous Message Alan Hodgson 2011-07-07 19:07:46 Re: Add Foreign Keys To Table