Re: Add sortsupport to money_ops, pg_lsn_ops and xid8_ops

On 11/9/26 08:53, David Rowley wrote:
> On Mon, 9 Nov 2026 at 17:10, Kirill Reshke <reshkekirill(at)gmail(dot)com> wrote:
>> It didn't occur to me that this would require any maintenance cost.
>> Saying that, I think money type is something people use
>
> Any basis for those thoughts? I've only ever seen its usage
> discouraged and even a short discussion [1] on how we might remove it
> one day.
>
> Perhaps we should make pg_upgrade start kicking out warnings in v20
> and then remove it in v25... Or reconsider that if we receive too many
> complaints.

Yeah, I think we should deprecate the money type. It is weird and
confusing to any user and the name makes some people think that it is
useful for storing money when it is generally not. I would rather that
we work on deprecating it over improving it. Maybe it can be turned into
an extension for the people who want it, but the issue is pg_upgrade and
type type oid.

--
Andreas Karlsson
Percona