| 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: | Whole Thread | Raw Message | 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? |