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

From: "Luiz Henrique" <luizhwk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: referential integrity violation - key referenced from xxx not found in yyy
Date: 2006-08-02 13:58:04
Message-ID: ba0a1f30608020658g2d7571d0vd49048694695b241@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2006-08-02 14:52:53 Re: BUG #2561: Manual is wrong: You can't grant a group to public
Previous Message Nikolay Samokhvalov 2006-08-02 07:37:03 Re: Fwd: [NOVICE] Trigger and Recursive Relation ?