As part of a nightly build process we are building an 8.0.1 database, creating a schema, etc. Intermittently we are getting the error
ERROR: index "xyz" is not a btree
In the archives I found a post from Tom http://archives.postgresql.org/pgsql-admin/2005-05/msg00103.php that suggested this was a bad pg build or a flaky harddrive. I will look into the hardware issue, but I was wondering in what way I could have screwed up the build of postgres to get this kind of error? I see where the error is being emitted in the _bt_getroot and _bt_gettrueroot methods, but I don't what would be configure/build sensitive in there.
Incidentally, when I try to search the archives on "is not a btree", I get all hits for btree, presumably because all of those other "little" words in the phrase are stop-listed? Is there an escape sequence I can use to get the search to work for only that whole phrase (I realize this is probably basic google stuff, but I was born before the web....)
Thanks.
- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130