Re: Add Foreign Keys To Table

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Thu, 7 Jul 2011 13:05:40 -0700 (PDT)

On Thu, 7 Jul 2011, John R Pierce wrote:

Since your PK of station_type is a composite, your foreign key must also be 
composite.

CREATE TABLE stuffed (
   id serial;
   otherestuffs text;
   sta varchar(50),
   sec varchar(50),
   FOREIGN KEY (sta, sec) REFERENCES station_type(sta_type, secondary_type) 
);

  Thanks, John, for showing me how to apply this approach.

Rich

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general