Re: referential integrity violation - key referenced from

From: "Luiz Henrique" <luizhwk(at)gmail(dot)com>
To: "Jim Nasby" <jnasby(at)pervasive(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-22 11:21:28
Message-ID: ba0a1f30608220421l68c82e1do109bcb02838a584b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)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(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 Douglas Toltzman 2006-08-22 18:37:56 Re: BUG #2587: Connection problem
Previous Message Sunil Kumar Basu 2006-08-22 08:20:55 BUG #2587: Connection problem