pgsql: Use mode "r" for popen() in psql's evaluate_backtick().

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Use mode "r" for popen() in psql's evaluate_backtick().
Date: 2020-10-28 18:36:19
Message-ID: E1kXqJ1-00037y-Aq@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Use mode "r" for popen() in psql's evaluate_backtick().

In almost all other places, we use plain "r" or "w" mode in popen()
calls (the exceptions being for COPY data). This one has been
overlooked (possibly because it's buried in a ".l" flex file?),
but it's using PG_BINARY_R.

Kensuke Okamura complained in bug #16688 that we fail to strip \r
when stripping the trailing newline from a backtick result string.
That's true enough, but we'd also fail to convert embedded \r\n
cleanly, which also seems undesirable. Fixing the popen() mode
seems like the best way to deal with this.

It's been like this for a long time, so back-patch to all supported
branches.

Discussion: https://postgr.es/m/16688-c649c7b69cd7e6f8@postgresql.org

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/504f963f76f0a5867b12cba8802e858cbfa53af9

Modified Files
--------------
src/bin/psql/psqlscanslash.l | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-10-28 21:03:15 pgsql: Doc: clean up verify_heapam() documentation.
Previous Message Tom Lane 2020-10-28 17:47:16 pgsql: Calculate extraUpdatedCols in query rewriter, not parser.