Postgres Pro
Downloads
Home   >   mailing lists

Re: referential integrity violation - key referenced from - Mailing list pgsql-bugs

From Jim Nasby
Subject Re: referential integrity violation - key referenced from
Date
Msg-id C64C1FE9-CB71-464F-97C1-DBF8D3B6ECCE@pervasive.com
Whole thread Raw
In response to Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
Responses Re: referential integrity violation - key referenced from
List pgsql-bugs
Tree view 
On Aug 15, 2006, at 8:50 AM, Luiz Henrique wrote:
> my problem was problably corrupted index files. I recreated the
> index and it's ok now. The hardware was being unpluged from power
> source without shuthing down, I guess that's the cause.

What version are you using? In recent versions, indexes are supposed
to be safe from corruption, even through crashes.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: reindexdb command utlility
Next
From: "Manuel A. Fernandez Montecelo"
Date:
Subject: Re: BUG #2585: Please provide pkg-config support