pgsql: Fix pg_dump to work against pre-9.0 servers again. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix pg_dump to work against pre-9.0 servers again.
Date
Msg-id E1bsVYl-0007Oc-Np@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix pg_dump to work against pre-9.0 servers again.

getBlobs' queries for pre-9.0 servers were broken in two ways:
the 7.x/8.x query uses DISTINCT so it can't have unspecified-type
NULLs in the target list, and both that query and the 7.0 one
failed to provide the correct output column labels, so that the
subsequent code to extract data from the PGresult would fail.

Back-patch to 9.6 where the breakage was introduced (by commit 23f34fa4b).

Amit Langote and Tom Lane

Discussion: <0a3e7a0e-37bd-8427-29bd-958135862f0a@lab.ntt.co.jp>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4806f26f9e4273888cbf85f42b3bdc5e9d950ba6

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 17 +++++++++--------
1 file changed, 9 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix pg_dump to work against pre-9.0 servers again.
Next
From: Tom Lane
Date:
Subject: pgsql: Fix python shlib probe for Cygwin.