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

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: <rtmeneses(at)7-eleven(dot)com(dot)ph>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Error Message: ERROR: UNIQUE constraint matching given keys for referenced table "item" not found
Date: 2003-09-04 18:32:01
Message-ID: 013d01c37312$d54e4d30$1f324d80@w2k
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)7-eleven(dot)com(dot)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?

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-09-04 19:40:32 Re: Error Message: ERROR: UNIQUE constraint matching given keys for referenced table 'item' not found
Previous Message Felipe Carreño 2003-09-04 18:16:25 Error Message: ERROR: formato de entrada de float8 incorrecto '1062432759, 21429'