Postgres Pro
Downloads
Home   >   mailing lists

Re: Escaping single quotes with backslash seems not to work - Mailing list pgsql-general

From Ron Johnson
Subject Re: Escaping single quotes with backslash seems not to work
Date
Msg-id CANzqJaAF+C5nXL6ZU+KROMNBbYYWY6XT8QXHPuhnOm+whdEodA@mail.gmail.com
Whole thread Raw
In response to Re: Escaping single quotes with backslash seems not to work  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Escaping single quotes with backslash seems not to work
List pgsql-general
Tree view
On Mon, Jun 10, 2024 at 11:42 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Jun 10, 2024 at 8:19 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

"set standard_encoding_strings = on" is at the top, and there's no other reference to it.


Well, if they are not using E-strings for escapes then you have the answer why v14 is broken.  Does it really matter why v9.6 apparently worked even though it should not have if that setting was also set to on?

It matters that something broke either between PG 9.6 and 14 OR the old JDBC driver and the new JDBC driver, because the client end users are HOPPING MAD.

(Don't ask why it wasn't caught in testing; that's beyond my control.)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq v17 PQsocketPoll timeout is not granular enough
Next
From: Dominique Devienne
Date:
Subject: Re: libpq v17 PQsocketPoll timeout is not granular enough