Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group