Re: Can we remove support for standard_conforming_strings = off yet?

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: John Naylor <johncnaylorls(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Can we remove support for standard_conforming_strings = off yet?
Date: 2026-01-21 10:32:11
Message-ID: aXCrK7vsVSNPWKui@jrouhaud
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, Jan 20, 2026 at 01:31:53PM -0500, Tom Lane wrote:
> So, nobody's actually spoken against this change. I think we should
> go forward with it, for the reasons I gave at the top of the thread
> and because "if not now, when?". I have little doubt that if there
> is anyone still running with standard_conforming_strings = off, they
> aren't going to change until forced to. So unless we want to live
> with the potential security hazard forever, we're going to have to
> make a breaking change sometime.

+1 from me. All of that is sensible, plus from an extension point of view it's
easy to write code that is broken with standard_conforming_strings = off so
it's one less thing to worry about.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-01-21 10:34:09 Re: Flush some statistics within running transactions
Previous Message Jakub Wartak 2026-01-21 10:30:03 Re: Adding basic NUMA awareness