Re: [GENERAL] index xyz is not a btree

2005-06-10 Thread David Parker
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 w

Re: [GENERAL] index xyz is not a btree

2005-06-10 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: > The error only happens intermittently, but every occurrence is > consistent: > > 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 co

[GENERAL] index xyz is not a btree

2005-06-10 Thread David Parker
We are getting the "index xyz is not a btree" error pretty frequently in our build system (in which we build several databases). This is with 8.0.1 on Solaris 9/intel. During a database build we create the database, import metadata, import some application data, then finally run a vacuum on