Re: ltree_gist indexes broken after pg_upgrade from 12 to 13

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ltree_gist indexes broken after pg_upgrade from 12 to 13
Дата
Msg-id 3976440.1646425725@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Nikita Glukhov <n.gluhov@postgrespro.ru>)
Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
> On 3/4/22 20:29, Nikita Glukhov wrote:
>> So, we probably have corrupted indexes that were updated since such 
>> "incomplete" upgrade of ltree.

> IIRC pg_upgrade is not expected to upgrade extensions - it keeps the
> installed version of the extension, and that's intentional.

Yeah, exactly.  But this opens up an additional consideration we
have to account for: whatever we do needs to work with either 1.1
or 1.2 SQL-level versions of the extension.

            regards, tom lane



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: SQL/JSON: JSON_TABLE
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b