Re: Do quoting more carefully in replication commands

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Do quoting more carefully in replication commands
Date: 2026-06-12 21:02:05
Message-ID: aixLY13bBTVdSAan@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Jun-12, Tom Lane wrote:

> (I envision back-patching this all the way, but have not yet
> looked at whether the back branches will require adjustments.)

In a quick skim, I wondered about this bit:

> + * Caution: this quoting logic is sufficient for identifiers and literals
> + * in the replication grammar, but not always in regular SQL. Specifically,
> + * it'd fail for a string literal if standard_conforming_strings is off.

... given that standard_conforming_strings can no longer be off in 19.
The backpatched version should surely still have this, just in case, but
in 19 it's probably not needed.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"After a quick R of TFM, all I can say is HOLY CR** THAT IS COOL! PostgreSQL was
amazing when I first started using it at 7.2, and I'm continually astounded by
learning new features and techniques made available by the continuing work of
the development team."
Berend Tober, http://archives.postgresql.org/pgsql-hackers/2007-08/msg01009.php

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-06-12 21:24:05 Re: Do quoting more carefully in replication commands
Previous Message Ayush Tiwari 2026-06-12 20:44:26 Re: fix prev link in docs