Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails
Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, adam@labkey.com, pgsql-bugs@lists.postgresql.org
Date: 2024-11-27T18:03:43Z
Lists: pgsql-bugs
On Wed, Nov 27, 2024 at 11:50:19AM -0600, Nathan Bossart wrote: > On Wed, Nov 27, 2024 at 05:43:38PM +0000, Bertrand Drouvot wrote: > > Regarding the question, the report that lead to the initial discussion was coming > > from a real case from an internal team. 562bee0fc1 did not fix it though but at > > least provides a consistent behavior between ASCII and non-ASCII. > > It may be more consistent, but if it didn't fix the issue for that user, > and it's breaking things for other users, then the added consistency seems > to have helped no one. Right. That would just avoid new "surprises" like the one that lead to the initial discussion. But as the pre-17 behavior was there since long enough, it looks like that the "surprises" are not that frequent though (or not reported). Indeed, reverting might be the way to go then (without waiting for more 17 behavior reports). Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
Commits
-
Revert "Don't truncate database and user names in startup packets."
- d09fbf645ece 17.3 landed
- a0ff56e2d3ff 18.0 landed
-
Don't truncate database and user names in startup packets.
- 562bee0fc13d 17.0 cited
-
Truncate incoming username and database name to NAMEDATALEN-1 characters
- d18c1d1f5102 7.1.1 cited