From d1644d9c31102e12560c864fae10bb7ab1826adb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 25 Nov 2011 14:34:51 -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 aa0b56c5a0d..d20939e28fc 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -11204,7 +11204,7 @@ dumpConstraint(Archive *fout, ConstraintInfo *coninfo) exit_nicely(); } - if (binary_upgrade && !coninfo->condef) + if (binary_upgrade) binary_upgrade_set_relfilenodes(q, indxinfo->dobj.catId.oid, true); appendPQExpBuffer(q, "ALTER TABLE ONLY %s\n", -- 2.39.5