Re: Escaping single quotes with backslash seems not to work

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Escaping single quotes with backslash seems not to work
Date: 2024-06-10 20:52:53
Message-ID: 35fb2ff3-9915-40ca-a8c5-3e5f6c9dd7cd@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/10/24 10:51, Ron Johnson wrote:
> On Mon, Jun 10, 2024 at 11:42 AM David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Mon, Jun 10, 2024 at 8:19 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)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.

What was the change in the JDBC driver version?

What is the error you are getting currently?

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-06-10 21:15:36 Re: Multiple tables row insertions from single psql input file
Previous Message Ron Johnson 2024-06-10 20:25:54 Re: Multiple tables row insertions from single psql input file