It's rumoured that Robert T. Meneses once said: > 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?
Hi, It seems that PostgreSQL wants to have a Unique constraint on the referenced columns. Can you try something like ALTER TABLE ref_table ADD CONSTRAINT ref_key UNIQUE (ref_col1, ref_col2); to add a unique contsraint? Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
