Error Message: ERROR: UNIQUE constraint matching given keys for referenced table "item" not found
От | Robert T. Meneses |
---|---|
Тема | Error Message: ERROR: UNIQUE constraint matching given keys for referenced table "item" not found |
Дата | |
Msg-id | 000001c37282$f9dfbb10$f001a8c0@ortigas.seveneleven.com обсуждение исходный текст |
Ответы |
Re: Error Message: ERROR: UNIQUE constraint matching given keys for referenced table 'item' not found
|
Список | pgadmin-support |
----------------------------------------- (on mailserver) email-body was scanned and no virus found. From MIS - Network Administrator --------------------------------------------------------- -- System Information -- Platform: Windows XP Version: 5.1 Build: 2600 Service Pack 1 -- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 7.3.2 Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux 8.0 3.2.2-1) -- Driver Information -- Name: PostgreSQL Version: 7.3.100 Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux -- 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?
В списке pgadmin-support по дате отправления: