
The above error refers to a btree index, correct?  Do/will a REINDEX fix 
that, or do I have to physically DROP/CREATE the INDEX?

This is a 7.4 database, if that matters ...

Thanks ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Fri, 27 Aug 2004 13:31:01 -0300 (ADT)
"Marc G. Fournier" <scrappy@postgresql.org>
PANIC:  right sibling's left-link doesn't match
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> The above error refers to a btree index, correct?  Do/will a REINDEX fix 
> that, or do I have to physically DROP/CREATE the INDEX?

REINDEX should fix it --- but how did it get that way?

			regards, tom lane

Fri, 27 Aug 2004 13:28:01 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: PANIC: right sibling's left-link doesn't match 
On Fri, 27 Aug 2004, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> The above error refers to a btree index, correct?  Do/will a REINDEX fix
>> that, or do I have to physically DROP/CREATE the INDEX?
>
> REINDEX should fix it --- but how did it get that way?

For lack of a better way of saying it, 'sporatic hardware failure' :(

But, REINDEX did fix it ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Fri, 27 Aug 2004 14:52:14 -0300 (ADT)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: PANIC: right sibling's left-link doesn't match 