Re: referential integrity violation - key referenced from

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Luiz Henrique <luizhwk(at)gmail(dot)com>
Cc: "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: referential integrity violation - key referenced from
Date: 2006-08-21 21:55:28
Message-ID: C64C1FE9-CB71-464F-97C1-DBF8D3B6ECCE@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-08-22 00:49:38 Re: BUG #2467: Documentation
Previous Message Stephan Szabo 2006-08-21 21:44:03 Re: truncate in combination with deferred triggers