Re: Error with index on unlogged table

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Error with index on unlogged table
Дата
Msg-id CAB7nPqR7H-B0BoKQNwGyJK0hPo3HZ0HFfQoLED=iYE2ouJHiyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Error with index on unlogged table  (Thom Brown <thom@linux.com>)
Ответы Re: Error with index on unlogged table  (Amit Langote <amitlangote09@gmail.com>)
Re: Error with index on unlogged table  (Andres Freund <andres@2ndquadrant.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Álvaro Hernández Tortosa
Дата:
Сообщение: Re: Repeatable read and serializable transactions see data committed after tx start
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Replication identifiers, take 4