From: | "Adam Fisher" <black(at)cia(dot)com(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | foreign key creation problem |
Date: | 2001-12-13 03:08:29 |
Message-ID: | 9v9683$2pbm$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I am trying to add a foreign key comstraint to an already-populated table
using the ALTER TABLE command. I am linking to the primary key of the master
table, and the slave table also has a primary key, however the field I am
adding the constraint to is not indexed.
When I try and create the constraint using:
alter table inventory
add constraint fk_inv_item_stkNo
foreign key ("stockNo") references "item" ("stockNo")
i get the following message:
UNIQUE constraint matching given keys for referenced table not found "item"
Can anybody tell me what I'm doing wrong? The field stockNo in the item
table is the primary key, so it is unique. Both fields have the dataType
integer and the primary key is also a sequence (i.e auto-incrementing)
thanks
adam
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Ryan | 2001-12-13 03:36:30 | Convert money type to int |
Previous Message | Joseph Shraibman | 2001-12-13 02:35:56 | dropping foreign keys |