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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "zhangsijing"
Дата:
Сообщение: BUG #1932: initdb.log
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1932: initdb.log