foreign key creation problem

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

Responses

Browse pgsql-general by date

  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