Re: Add Foreign Keys To Table

From: Alan Hodgson
Subject: Re: Add Foreign Keys To Table
Date: ,
Msg-id: 201107071207.46656.ahodgson@simkin.ca
(view: Whole thread, Raw)
In response to: Re: Add Foreign Keys To Table  (Rich Shepard)
Responses: Re: Add Foreign Keys To Table  (Rich Shepard)
List: pgsql-general

Tree view

Add Foreign Keys To Table  (Rich Shepard, )
 Re: Add Foreign Keys To Table  (Alan Hodgson, )
  Re: Add Foreign Keys To Table  (Rich Shepard, )
   Re: Add Foreign Keys To Table  (Alan Hodgson, )
    Re: Add Foreign Keys To Table  (Rich Shepard, )
     Re: Add Foreign Keys To Table  (Alan Hodgson, )
      Re: Add Foreign Keys To Table  (Rich Shepard, )
       Re: Add Foreign Keys To Table  (John R Pierce, )
        Re: Add Foreign Keys To Table  (Rich Shepard, )
     Re: Add Foreign Keys To Table  ("David Johnston", )
 Re: Add Foreign Keys To Table  (John R Pierce, )
  Re: Add Foreign Keys To Table  (Rich Shepard, )
 Re: Add Foreign Keys To Table  ("David Johnston", )
 Re: Add Foreign Keys To Table  ("Dr. Tingrong Lu", )

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:

From: "Dr. Tingrong Lu"
Date:
Subject: Re: Add Foreign Keys To Table
From: Joe Lester
Date:
Subject: Re: failed archive command