referential integrity violation - key referenced from xxx not found in yyy

Поиск
Список
Период
Сортировка
От Luiz Henrique
Тема referential integrity violation - key referenced from xxx not found in yyy
Дата
Msg-id ba0a1f30608020658g2d7571d0vd49048694695b241@mail.gmail.com
обсуждение исходный текст
Ответы Re: referential integrity violation - key referenced from  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-bugs
Дерево обсуждения 
Hi,

I'm running Postgresql 7.3 in Debian Woody OS.

After some time working properly, insert's statements related this error:

----
referential integrity violation - key referenced from xxx not found in yyy
----

This error would be normal, if the key really doesn't exist, but the key
exist.
The insert's work some times, and some times don't.


Is there any file corrupted?
Removing the fk constraint would resolve the problem?

Thanks!!

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "flash.xu"
Дата:
Сообщение: BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return ""
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #2561: Manual is wrong: You can't grant a group to public