btree_gist extension - gbt_cash_union return type

Поиск
Список
Период
Сортировка
От Tim Kane
Тема btree_gist extension - gbt_cash_union return type
Дата
Msg-id CADVWZZ+aWNjmn+F1zoj8o2vZJhouA1JAOLuUp49bad4Yz7V8yw@mail.gmail.com
обсуждение исходный текст
Ответы Re: btree_gist extension - gbt_cash_union return type
Список 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

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Suggestion to improve query performance of data validation in proc.
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Logical replication troubles