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?
