From 35e27226b6751a90c9c911d08cb47b9f8a58825f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 25 Nov 2011 14:35:52 -0500 Subject: [PATCH] Allow pg_upgrade to upgrade clusters that use exclusion contraints by fixing pg_dump to properly preserve such indexes. Backpatch to 9.1 and 9.0 (where the bug was introduced). --- src/bin/pg_dump/pg_dump.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 9bbf962cd0..28a527357f 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -12948,7 +12948,7 @@ dumpConstraint(Archive *fout, ConstraintInfo *coninfo) exit_nicely(); } - if (binary_upgrade && !coninfo->condef) + if (binary_upgrade) binary_upgrade_set_pg_class_oids(q, indxinfo->dobj.catId.oid, true); appendPQExpBuffer(q, "ALTER TABLE ONLY %s\n", -- 2.40.0