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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
