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