On Wed, 2 Aug 2006, Luiz Henrique wrote:
> 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
> The insert's work some times, and some times don't.
> Is there any file corrupted?
It's hard to say. I'd have expected that a select * from parent where
key=value would fail for both the fk check and for a check to see if the
key exists assuming they used the same plan. Can you make a standalone
> Removing the fk constraint would resolve the problem?
Well, it'd stop the message, but if there is corruption, it wouldn't fix
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-08-02 16:31:32|
|Subject: Re: BUG #2561: Manual is wrong: You can't grant a group to public |
|Previous:||From: Brian Hurt||Date: 2006-08-02 14:58:47|
|Subject: Re: BUG #2561: Manual is wrong: You can't grant a group to|