Re: ltree_gist indexes broken after pg_upgrade from 12 to 13 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: ltree_gist indexes broken after pg_upgrade from 12 to 13
Date
Msg-id 682EB55D-631C-4256-9866-C3FD4CF6CD3C@anarazel.de
Whole thread Raw
In response to Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: Support custom authentication methods using hooks
Next
From: Peter Smith
Date:
Subject: Re: Design of pg_stat_subscription_workers vs pgstats