Re: index xyz is not a btree - Mailing list pgsql-general

From David Parker
Subject Re: index xyz is not a btree
Date
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C746FEE@corpsrv2.tazznetworks.com
Whole thread Raw
In response to index xyz is not a btree  ("David Parker" <dparker@tazznetworks.com>)
List pgsql-general
No, I haven't tried that - I wasn't aware of pg_filedump. What's tricky
is that when the build detects a failure, it deletes the output
directory (so we don't get left with a half-built db) so I'll have to
fiddle with it....

I just downloaded pg_filedump from the redhat site, so I'll play around
with it, and report back if/when I find anything.

Thanks.

- DAP


>>     1) always the same index - "attribute_pkey" on our "attirbute"
>> table
>> - one created implicitly by a primary key constraint
>>     2) the error happens during a vacuum command
>
>Hmm ... that seems a bit too consistent for a hardware issue
>doesn't it?
>
>Have you looked at the index file with pg_filedump, or even just od?
>
>            regards, tom lane
>

pgsql-general by date:

Previous
From: H Hale
Date:
Subject: Re: foreign key constraint not being respected with type created by CREATE TYPE
Next
From: Marc Munro
Date:
Subject: Waiting for select