Postgres Pro
Downloads
Home   >   mailing lists

referential integrity violation - key referenced from xxx not found in yyy - Mailing list pgsql-bugs

From Luiz Henrique
Subject referential integrity violation - key referenced from xxx not found in yyy
Date
Msg-id ba0a1f30608020658g2d7571d0vd49048694695b241@mail.gmail.com
Whole thread Raw
Responses Re: referential integrity violation - key referenced from  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "flash.xu"
Date:
Subject: BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return ""
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #2561: Manual is wrong: You can't grant a group to public