Re: Error with index on unlogged table

On 2015-03-26 13:55:22 +0000, Thom Brown wrote:
> I still, however, have a problem with the separate and original issue of:
> 
> # insert into utest (thing) values ('moomoo');
> ERROR:  index "utest_pkey" contains unexpected zero page at block 0
> HINT:  Please REINDEX it.
> 
> I don't see why the user should need to go re-indexing all unlogged tables
> each time a standby is promoted.  The index should just be empty and ready
> to use.

There's definitely something rather broken here. Investigating.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services