From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Error with index on unlogged table |
Date: | 2015-03-24 08:53:06 |
Message-ID: | CAA-aLv7T3dK0TPL8hkQBfgZghgDz_azbAhE_PSm3Ania-=UCKw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Venkata Balaji N | 2015-03-24 10:12:03 | Re: recovery_target_time ignored ? |
Previous Message | David Rowley | 2015-03-24 07:16:06 | Re: Order of enforcement of CHECK constraints? |