Re: foreign key creation problem

On Thu, 13 Dec 2001, Adam Fisher wrote:

> 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)

Can you send the full schema of the tables involved?