BUG #1802: index is not a btree

From: "Jenny Wang" <y6108(at)vip(dot)sina(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1802: index is not a btree
Date: 2005-08-03 03:17:15
Message-ID: 20050803031715.8A287F0B0F@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1802
Logged by: Jenny Wang
Email address: y6108(at)vip(dot)sina(dot)com
PostgreSQL version: 7.3.10
Operating system: RedHat 8
Description: index is not a btree
Details:

1 $ cd <prefix>
$ cd bin

2 $ ./postmaster -D data &
$ ./psql TEST
TEST=#create table a(col1 int primary key);

3 $ kill -9 <postmaster pid>

4 $ ./postmaster -D data &
$ ./psql TEST
TEST=#insert into a values(1);

ERROR: Index a_pkey is not a btree

the file of a_pkey has size 8k, and is all zero.

Browse pgsql-bugs by date

  From Date Subject
Next Message Qingqing Zhou 2005-08-03 09:09:06 Re: Server broken down in covering GB18030
Previous Message Peter Valach 2005-08-02 22:00:12 BUG #1801: pg_dump dumps tables in alphabetical order, not as created