public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Escaping single quotes with backslash seems not to work
Date: Mon, 10 Jun 2024 11:19:32 -0400
Message-ID: <CANzqJaDqZtWfk=s1_886m7TzTMek87Qcefpns4WRBvjm-9f-_w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CANzqJaD0=V+Dh+mLLfLj4ECLHriAH122LiYaqKyAnWCAKCfa6A@mail.gmail.com>
<CAKFQuwbdAm7=RziKxF+jQki0KXb-quan5fA3sfq8JKoDR3Jumw@mail.gmail.com>
<CANzqJaCL_p2LmCAUPGUYxOJPN-iOs-JWbpU4ssH+rSw27DmvhA@mail.gmail.com>
<CAKFQuwZhOgbn+wbDTRXyqON2AEJM-R_Na2yHjLD0r9V4a+Fx=Q@mail.gmail.com>
<CANzqJaDTY0AEB2zxumCbDtZu_pVxcjWpf5FdSeGwShLM3SfVzg@mail.gmail.com>
<[email protected]>
On Mon, Jun 10, 2024 at 11:08 AM Tom Lane <[email protected]> wrote:
> Ron Johnson <[email protected]> writes:
> > On Mon, Jun 10, 2024 at 10:56 AM David G. Johnston <
> > [email protected]> 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.
>
It's a remote Java app which runs as a non-superuser. I don't know what
it's doing.
I ran "pg_dumpuser -g" on the old systems, and applied the sql to the
corresponding new servers.
"set standard_encoding_strings = on" is at the top, and there's no other
reference to it.
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Escaping single quotes with backslash seems not to work
In-Reply-To: <CANzqJaDqZtWfk=s1_886m7TzTMek87Qcefpns4WRBvjm-9f-_w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox