Re: BUG #17767: psql: tab-completion causes warnings when standard_conforming_strings = off

On 2023-Feb-06, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > Hmm, really? We could just remove it for 16; people will still be able
> > to use the warnings mode in 15 for several years, so if they want to
> > upgrade to 16+ they will have plenty of time to update their apps.
>
> I think removing standard_conforming_strings = off might be a
> bridge too far, even yet. Or were you speaking of removing
> escape_string_warning? I could get behind that perhaps.
> Making it default to off could be an even easier sell.

I was thinking we'd remove them together. Anybody who is running
standard_conforming_strings=off will need the warning so that they can
find the places they need to touch in order to migrate. Keeping the
ability to run nonstandard strings but without the ability to have the
warnings would be dangerous, because then there's no easy way to
upgrade.

So, if we want to keep standard_conforming_strings=off, then by all
means let's keep the warning too.

(I agree BTW with the idea that running psql with non-standard strings
and the warnings enabled is not something that we need to support
specifically.)

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)