From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Bossart <nathandbossart@gmail.com>
cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>,
        Bruce Momjian <bruce@momjian.us>, adam@labkey.com,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18711: Attempting a connection with a database name longer
 than 63 characters now fails
In-reply-to: <Z0c9XVU6aTd8neRr@nathan>
References: <Zz9OTyWAvATeeHev@nathan> <Zz9jfOkVmlYcYHSy@momjian.us>
 <Zz9pOi3pGF-DnJTp@nathan> <Zz92cka2VlBDsat3@momjian.us>
 <Zz94l3LHsML0V9eu@nathan>
 <Z0A2o+dS0MqDE2Fs@ip-10-97-1-34.eu-west-3.compute.internal>
 <659706.1732303427@sss.pgh.pa.us> <Z0DjJbJV4ZWkLuQd@nathan>
 <665338.1732306066@sss.pgh.pa.us> <Z0Dmw1ryKH8bEkyo@nathan>
 <Z0c9XVU6aTd8neRr@nathan>
Comments: In-reply-to Nathan Bossart <nathandbossart@gmail.com>
	message dated "Wed, 27 Nov 2024 09:40:13 -0600"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1865226.1732723416.1@sss.pgh.pa.us>
Date: Wed, 27 Nov 2024 11:03:36 -0500
Message-ID: <1865227.1732723416@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1865227.1732723416%40sss.pgh.pa.us>
Precedence: bulk

Nathan Bossart <nathandbossart@gmail.com> writes:
> That being said, I'm growing quite uneasy about the size of this hack, and
> I'm wondering if it would be better to leave it alone (perhaps with an
> update to the release notes) or just revert commit 562bee0 until we have a
> better way of dealing with multibyte characters in identifiers (e.g.,
> tracking their encoding).  I suspect there are similar problems in other
> places (e.g., pg_dumpall).

Yeah, there is something to be said for reverting.  There is nothing
about our handling of non-ASCII characters in shared system catalogs
that isn't squishy as heck, and yet there have been darn few field
complaints over the many years it's been like that.  Maybe trying to
make this truncation issue better in isolation wasn't such a great
plan.

(If we recorded the encoding of names in shared catalogs then this
particular issue would be far easier to solve, but then we have
other problems to address --- particularly, what to do if a name
in the catalog fails to convert to the encoding we are using.)

			regards, tom lane