BUG #1930: Cannot create foreign key constraint
От | Warren Little |
---|---|
Тема | BUG #1930: Cannot create foreign key constraint |
Дата | |
Msg-id | 20051001153221.490C0F0D5F@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1930: Cannot create foreign key constraint
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1930 Logged by: Warren Little Email address: warren.little@reardeninc.com PostgreSQL version: 8.0.3 Operating system: 2.6.10-1.770_FC3smp #1 SMP Thu Feb 24 18:36:43 EST 2005 x86_64 x86_64 x86_64 GNU/Linux Description: Cannot create foreign key constraint Details: pg_restore generates the following error: pg_restore: [archiver (db)] Error from TOC entry 2950; 16386 17827531 FK CONSTRA INT asientry_r0 tigris pg_restore: [archiver (db)] could not execute query: ERROR: insert or update on table "asientry" violates foreign key constraint "asientry_r0" DETAIL: Key (pid)=(AA0003403544) is not present in table "pobject". Command was: ALTER TABLE ONLY asientry ADD CONSTRAINT asientry_r0 FOREIGN KEY (pid) REFERENCES pobject(pid); Also running the alter table after restore generates same constraint violation error. The following query returns one row: select * from asientry, pobject where pobject.pid = 'AA0003403544' and pobject.pid = asientry.pid; Any ideas
В списке pgsql-bugs по дате отправления: