btree_gist extension - gbt_cash_union return type

From: Tim Kane <tim(dot)kane(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: btree_gist extension - gbt_cash_union return type
Date: 2020-05-22 08:19:57
Message-ID: CADVWZZ+aWNjmn+F1zoj8o2vZJhouA1JAOLuUp49bad4Yz7V8yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've noticed a discrepancy in the return type for the gbt_cash_union
function...

On fresh instances of postgres 9.6.11, where the btree_gist extension is
newly created (version 1.2) yields a gbt_cash_union function with a return
type of gbtreekey16

While instances that have been upgraded from 9.6.2 to 9.6.11, where the
btree_gist was originally installed as 1.0 and then upgraded from 1.0 to
1.2 - that same function has a return type of gbtreekey8

I expect something is missing from the extension upgrade script to modify
the return type.

Is it safe/recommended to modify this function to return gbtreekey16?
Perhaps safer still to drop the extension and recreate it?

Thanks in advance. If this should be considered a bug, and there is a
better place to report such - please advise.

Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2020-05-22 09:00:11 Re: Logical replication troubles
Previous Message David G. Johnston 2020-05-22 08:09:40 Re: Suggestion to improve query performance of data validation in proc.