To do what you want to do look up "CREATE INDEX" in the documentation. You may wish to provide the PK/FK schema for the tables in questions as it appears - at first take - that you are doing something wrong If you have a compound Primary Key with component fields that are also "UNIQUE". You probably need to add "BOTH" fields to "station_information" and then say something like. FOREIGN KEY (field1, field2) REFERENCES table (field1, field2) ... David J. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rich Shepard Sent: Thursday, July 07, 2011 3:31 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Add Foreign Keys To Table 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
