Re: Can we remove support for standard_conforming_strings = off yet? - Mailing list pgsql-hackers

On Mon, Jan 05, 2026 at 05:03:48PM +0700, John Naylor wrote:
> On Thu, Jan 1, 2026 at 12:04 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Personally I would call it a deal-breaker if I thought it'd affect
> > more than a very very tiny number of people.  But the entire premise
> > of this patch is that nobody is using standard_conforming_strings =
> > off in production anymore.  If that isn't true it's probably a
> > mistake to go forward anyway.
> 
> FWIW, I spent a few minutes looking, and I only found issues from ~5
> years ago about software not working with the setting off. I didn't
> see any details on what they were running in the application stack
> that required it:
> 
> https://github.com/PostgREST/postgrest/issues/1992
> 
> https://github.com/npgsql/npgsql/issues/3333

I had another one ~4 years ago:

https://github.com/powa-team/powa-archivist/issues/51

Since I fixed powa-archivist at that time, I don't know if anyone else would
have faced the same problem, although the OP is likely still using the same
setting.