]> granicus.if.org Git - postgresql/commit
Fix pg_dump to work against pre-9.0 servers again.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 7 Oct 2016 13:51:18 +0000 (09:51 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 7 Oct 2016 13:51:28 +0000 (09:51 -0400)
commit1749332ec9e5017ca7ebfa245597cc765b4553fd
treec71d9d3ad6e214c7c4819ff26fa1e0a27ca806fb
parent2933ed0362ae5fbc9e0c28035286318b4d299492
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>
src/bin/pg_dump/pg_dump.c