On Wed, 2 Aug 2006, Luiz Henrique wrote: > 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?
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 test case? > Removing the fk constraint would resolve the problem? Well, it'd stop the message, but if there is corruption, it wouldn't fix that. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
