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

From Luiz Henrique
Subject Re: referential integrity violation - key referenced from
Date
Msg-id ba0a1f30608220421l68c82e1do109bcb02838a584b@mail.gmail.com
Whole thread Raw
In response to Re: referential integrity violation - key referenced from  (Jim Nasby <jnasby@pervasive.com>)
Responses Re: referential integrity violation - key referenced from  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
It's Postgresql 7.2.1, installed with stable version of Debian Woody, at the
time.


On 8/21/06, Jim Nasby <jnasby@pervasive.com> wrote:
>
> 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: "Sunil Kumar Basu"
Date:
Subject: BUG #2587: Connection problem
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #2585: Please provide pkg-config support