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

From Michael Paquier
Subject Re: Error with index on unlogged table
Date
Msg-id CAB7nPqR7H-B0BoKQNwGyJK0hPo3HZ0HFfQoLED=iYE2ouJHiyQ@mail.gmail.com
Whole thread Raw
In response to Re: Error with index on unlogged table  (Thom Brown <thom@linux.com>)
Responses Re: Error with index on unlogged table  (Amit Langote <amitlangote09@gmail.com>)
Re: Error with index on unlogged table  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Tue, Mar 24, 2015 at 8:46 PM, Thom Brown wrote:
> The index is unlogged until reindexing...
>
> [...]
> Which is think also raises the question, why are unlogged indexes made
> persistent by a reindex?

That's a bug of HEAD, ~9.4 keeping the index as unlogged even after
REINDEX INDEX. What happens is that ReindexIndex relies on
relpersistence provided by makeRangeVar at parse time, which is just
incorrect as it uses RELPERSISTENCE_PERMANENT all the time. The patch
attached fixes that...
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Álvaro Hernández Tortosa
Date:
Subject: Re: Repeatable read and serializable transactions see data committed after tx start
Next
From: Robert Haas
Date:
Subject: Re: Replication identifiers, take 4