pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix default signature length for gist_ltree_ops 3+ messages / 1 participants [nested] [flat]
* pgsql: Fix default signature length for gist_ltree_ops @ 2022-03-16 09:02 Alexander Korotkov <akorotkov@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Alexander Korotkov @ 2022-03-16 09:02 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix default signature length for gist_ltree_ops 911e702077 implemented operator class parameters including the signature length in ltree. Previously, the signature length for gist_ltree_ops was 8. Because of bug 911e702077 the default signature length for gist_ltree_ops became 28 for ltree 1.1 (where options method is NOT provided) and 8 for ltree 1.2 (where options method is provided). This commit changes the default signature length for ltree 1.1 to 8. Existing gist_ltree_ops indexes might be corrupted in various scenarios. Thus, we have to recommend reindexing all the gist_ltree_ops indexes after the upgrade. Reported-by: Victor Yegorov Reviewed-by: Tomas Vondra, Tom Lane, Andres Freund, Nikita Glukhov Reviewed-by: Andrew Dunstan Author: Tomas Vondra, Alexander Korotkov Discussion: https://postgr.es/m/17406-71e02820ae79bb40%40postgresql.org Discussion: https://postgr.es/m/d80e0a55-6c3e-5b26-53e3-3c4f973f737c%40enterprisedb.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/7e74aafc4335e743199c6c68ca9dd539053db9e5 Modified Files -------------- contrib/ltree/ltree.h | 8 +++++--- contrib/ltree/ltree_gist.c | 12 ++++++------ 2 files changed, 11 insertions(+), 9 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Fix default signature length for gist_ltree_ops @ 2022-03-16 09:02 Alexander Korotkov <akorotkov@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Alexander Korotkov @ 2022-03-16 09:02 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix default signature length for gist_ltree_ops 911e702077 implemented operator class parameters including the signature length in ltree. Previously, the signature length for gist_ltree_ops was 8. Because of bug 911e702077 the default signature length for gist_ltree_ops became 28 for ltree 1.1 (where options method is NOT provided) and 8 for ltree 1.2 (where options method is provided). This commit changes the default signature length for ltree 1.1 to 8. Existing gist_ltree_ops indexes might be corrupted in various scenarios. Thus, we have to recommend reindexing all the gist_ltree_ops indexes after the upgrade. Reported-by: Victor Yegorov Reviewed-by: Tomas Vondra, Tom Lane, Andres Freund, Nikita Glukhov Reviewed-by: Andrew Dunstan Author: Tomas Vondra, Alexander Korotkov Discussion: https://postgr.es/m/17406-71e02820ae79bb40%40postgresql.org Discussion: https://postgr.es/m/d80e0a55-6c3e-5b26-53e3-3c4f973f737c%40enterprisedb.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/7d30f59da714ab25f82f4bc24f30cba1022d8cb9 Modified Files -------------- contrib/ltree/ltree.h | 8 +++++--- contrib/ltree/ltree_gist.c | 12 ++++++------ 2 files changed, 11 insertions(+), 9 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Fix default signature length for gist_ltree_ops @ 2022-03-16 09:03 Alexander Korotkov <akorotkov@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Alexander Korotkov @ 2022-03-16 09:03 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix default signature length for gist_ltree_ops 911e702077 implemented operator class parameters including the signature length in ltree. Previously, the signature length for gist_ltree_ops was 8. Because of bug 911e702077 the default signature length for gist_ltree_ops became 28 for ltree 1.1 (where options method is NOT provided) and 8 for ltree 1.2 (where options method is provided). This commit changes the default signature length for ltree 1.1 to 8. Existing gist_ltree_ops indexes might be corrupted in various scenarios. Thus, we have to recommend reindexing all the gist_ltree_ops indexes after the upgrade. Reported-by: Victor Yegorov Reviewed-by: Tomas Vondra, Tom Lane, Andres Freund, Nikita Glukhov Reviewed-by: Andrew Dunstan Author: Tomas Vondra, Alexander Korotkov Discussion: https://postgr.es/m/17406-71e02820ae79bb40%40postgresql.org Discussion: https://postgr.es/m/d80e0a55-6c3e-5b26-53e3-3c4f973f737c%40enterprisedb.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/bad202c615c9f4ad41be18aa7d9ffe41ebfb86fa Modified Files -------------- contrib/ltree/ltree.h | 8 +++++--- contrib/ltree/ltree_gist.c | 12 ++++++------ 2 files changed, 11 insertions(+), 9 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-03-16 09:03 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-03-16 09:02 pgsql: Fix default signature length for gist_ltree_ops Alexander Korotkov <akorotkov@postgresql.org> 2022-03-16 09:02 pgsql: Fix default signature length for gist_ltree_ops Alexander Korotkov <akorotkov@postgresql.org> 2022-03-16 09:03 pgsql: Fix default signature length for gist_ltree_ops Alexander Korotkov <akorotkov@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox