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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
