Horton

pg_dump: Fix query for gathering attribute stats on older versions.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: f0d0083f52f994989b1bb6723e7bd0fad9f586cd
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2025-04-05T02:05:30Z
Releases: 18.0 
pg_dump: Fix query for gathering attribute stats on older versions.

Commit 9c02e3a986 taught pg_dump to retrieve attribute statistics
for 64 relations at a time.  pg_dump supports dumping from v9.2 and
newer versions, but our query for retrieving statistics for
multiple relations uses WITH ORDINALITY and multi-argument
UNNEST(), both of which were introduced in v9.4.  To fix, we resort
to gathering statistics for a single relation at a time on versions
older than v9.4.

Per buildfarm member crake.

Author: Corey Huinker <corey.huinker@gmail.com>
Discussion: https://postgr.es/m/Z_BcWVMvlUIJ_iuZ%40nathan

Files

PathChange+/−
src/bin/pg_dump/pg_dump.c modified +30 −8

Discussion