On Mon, Jun 10, 2024 at 11:08 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> On Mon, Jun 10, 2024 at 10:56 AM David G. Johnston <
> david.g.johnston@xxxxxxxxx> 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.
