Re: FWD: bug report: index is not a btree - Mailing list pgsql-bugs

On Wed, Aug 03, 2005 at 09:46:23AM -0000, Greg Sabino Mullane wrote:
>
> 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.

I can duplicate this in 7.3.10, but only if the postmaster does a
redo when it restarts.  If I do a checkpoint before killing the
postmaster then the insert succeeds.

I couldn't duplicate this behavior in 7.4.8, 8.0.3, or HEAD.  The
7.4 Release Notes have an item about making B-tree indexes fully
WAL-safe, so I wonder if that fixes the problem.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/