Re: Error Message: ERROR: UNIQUE constraint matching given keys for referenced table "item" not found

Dear Robert.

I thinks that you must specify UNIQUE or PRIMARY KEY in "column of item" 
so that it should refer to it in the constraint "column of item".

Regards,
Hiroshi Saito

From: "Robert T. Meneses" <rtmeneses@7-eleven.com.ph>
(snip)

> -- Error Information --
>
> Description: ERROR:  UNIQUE constraint matching given keys for referenced
> table "item" not found
> Number: -2147467259
> Routine: pgAdmin II:frmTable.cmdOK_Click
>
> Insert your comment:
> Im having trouble creating foreign key for this table (itemsupp) both have
> itemcode column but when I created this error occur telling UNIQUE contraint
> matching. What shall I do?