From b8032e96ad1865a824ea2feb2f2a34f9b29ac6ac Mon Sep 17 00:00:00 2001 From: Stephen Frost Date: Tue, 10 May 2016 12:55:11 -0400 Subject: [PATCH] Qualify table usage in dumpTable() All of the other tables used in the query in dumpTable(), which is collecting column-level ACLs, are qualified, so we should be qualifying the pg_init_privs and related sub-select against pg_class too. Pointed out by Noah, patch by me. --- src/bin/pg_dump/pg_dump.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 1267afb..4a9b1bf 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -14992,9 +14992,10 @@ dumpTable(Archive *fout, TableInfo *tbinfo) "%s AS initrattacl " "FROM pg_catalog.pg_attribute at " "JOIN pg_catalog.pg_class c ON (at.attrelid = c.oid) " - "LEFT JOIN pg_init_privs pip ON " + "LEFT JOIN pg_catalog.pg_init_privs pip ON " "(pip.classoid = " - "(SELECT oid FROM pg_class WHERE relname = 'pg_class') AND " + "(SELECT oid FROM pg_catalog.pg_class " + "WHERE relname = 'pg_class') AND " " at.attrelid = pip.objoid AND at.attnum = pip.objsubid) " "WHERE at.attrelid = '%u' AND " "NOT at.attisdropped " -- 2.5.0