Re: ltree_gist indexes broken after pg_upgrade from 12 to 13

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: ltree_gist indexes broken after pg_upgrade from 12 to 13
Дата
Msg-id 682EB55D-631C-4256-9866-C3FD4CF6CD3C@anarazel.de
обсуждение исходный текст
Ответ на Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

On February 24, 2022 5:44:57 PM PST, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
>> I wonder if we could check the index tuple length, and adjust the siglen
>> based on that, somehow ...
>
>In an already-corrupted index, there won't be a unique answer.

If we're breaking every ltree gist index, can we detect that it's not an index generated by the new version? Most
peopledon't read release notes, and this is just about guaranteed to break all.  
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: Support custom authentication methods using hooks
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Design of pg_stat_subscription_workers vs pgstats