The following bug has been logged online:
Bug reference: 1802
Logged by: Jenny Wang
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.10
Operating system: RedHat 8
Description:index is not a btree
Details:
1 $ cd
$ cd bin
2 $ ./postmaster -D data &
$ .
On Wed, Aug 03, 2005 at 09:46:23AM -, Greg Sabino Mullane wrote:
>
> 2 $ ./postmaster -D data &
> $ ./psql TEST
> TEST=#create table a(col1 int primary key);
>
> 3 $ kill -9
>
> 4 $ ./postmaster -D data &
> $ ./psql TEST
> TEST=#insert into a values(1);
>
> ERROR: Index a_pkey
Michael Fuhr <[EMAIL PROTECTED]> writes:
> 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 Not
