From: Daniel Verite <daniel@manitou-mail.org>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Built-in CTYPE provider
Date: Fri, 12 Jan 2024 19:00:28 +0100
Message-ID: <1ecded1b-4ff8-46da-9b94-6e240db2a23b@manitou-mail.org> (raw)
In-Reply-To: <d9da5abdc0e485eef26937fe64e0af3b44098794.camel@j-davis.com>
Jeff Davis wrote:
> > Jeremy also raised a problem with old versions of psql connecting to
> > a
> > new server: the \l and \dO won't work. Not sure exactly what to do
> > there, but I could work around it by adding a new field rather than
> > renaming (though that's not ideal).
>
> I did a bit of research for a precedent, and the closest I could find
> is that \dp was broken between 14 and 15 by commit 07eee5a0dc.
Another one is that version 12 broke \d in older psql by
removing pg_class.relhasoids.
ISTM that in general the behavior of old psql vs new server does
not weight much against choosing optimal catalog changes.
There's also that warning at start informing users about it:
WARNING: psql major version X, server major version Y.
Some psql features might not work.
Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: daniel@manitou-mail.org, pgsql@j-davis.com, robertmhaas@gmail.com, schneider@ardentperf.com
Subject: Re: Built-in CTYPE provider
In-Reply-To: <1ecded1b-4ff8-46da-9b94-6e240db2a23b@manitou-mail.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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