Error with index on unlogged table - Mailing list pgsql-hackers

From Thom Brown
Subject Error with index on unlogged table
Date
Msg-id CAA-aLv7T3dK0TPL8hkQBfgZghgDz_azbAhE_PSm3Ania-=UCKw@mail.gmail.com
Whole thread Raw
Responses Re: Error with index on unlogged table  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi,

I was attempting to set up a data set to test pg_rewind, when I encountered an error.  I created a primary and standby, then:

# create table test (id serial primary key, thing text);
CREATE TABLE

# create unlogged table utest (id serial primary key, thing text);
CREATE TABLE

# insert into test (thing) values ('jifj');
INSERT 0 1

# insert into utest (thing) values ('jifj');
INSERT 0 1

$ pg_ctl -D standby1 promote

$ psql -p 5531 postgres # standby

# insert into test (thing) values ('moomoo');
INSERT 0 1

# insert into utest (thing) values ('moomoo');
ERROR:  index "utest_pkey" contains unexpected zero page at block 0
HINT:  Please REINDEX it.

This is built on commit e5f455f59fed0632371cddacddd79895b148dc07.
--
Thom

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Order of enforcement of CHECK constraints?
Next
From: Venkata Balaji N
Date:
Subject: Re: recovery_target_time ignored ?