Re: Escaping single quotes with backslash seems not to work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Escaping single quotes with backslash seems not to work
Date: 2024-06-10 15:08:31
Message-ID: 730017.1718032111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ronljohnsonjr(at)gmail(dot)com> writes:
> On Mon, Jun 10, 2024 at 10:56 AM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>> As the caution on that page says the default for standard conforming
>> strings changed in 9.1. But maybe your 9.6 had the old value configured but
>> when you upgraded to 14 you decided to go with the new default.

> That was the first thing I checked... It's the same on both the 9.6 and 14
> systems:.

Did you check that as the user that runs the Java app (I sure hope
it's not the superuser you evidently used here), in the DB the Java
app uses? I'm wondering about per-user or per-DB settings of
standard_conforming_strings.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-06-10 15:19:32 Re: Escaping single quotes with backslash seems not to work
Previous Message Ron Johnson 2024-06-10 14:59:22 Re: Escaping single quotes with backslash seems not to work