Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group