From 7b158d1baed859971c1aa792bff6a7e1f721cf91 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 25 May 2011 16:26:45 -0400 Subject: [PATCH] Suppress extensions in partial dumps. We initially had pg_dump emit CREATE EXTENSION commands unconditionally. However, pg_dump has long been in the habit of not dumping procedural language definitions when a --schema or --table switch is given. It seems appropriate to handle extensions the same way, since like PLs they are SQL objects that are not in any particular schema. Per complaint from Adrian Schreyer. --- src/bin/pg_dump/pg_dump.c | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 80bc9a96ca..f925be1ffa 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -1153,10 +1153,11 @@ selectDumpableDefaultACL(DefaultACLInfo *dinfo) * selectDumpableExtension: policy-setting subroutine * Mark an extension as to be dumped or not * - * Normally, we just dump all extensions. However, in binary-upgrade mode - * it's necessary to skip built-in extensions, since we assume those will - * already be installed in the target database. We identify such extensions - * by their having OIDs in the range reserved for initdb. + * Normally, we dump all extensions, or none of them if include_everything + * is false (i.e., a --schema or --table switch was given). However, in + * binary-upgrade mode it's necessary to skip built-in extensions, since we + * assume those will already be installed in the target database. We identify + * such extensions by their having OIDs in the range reserved for initdb. */ static void selectDumpableExtension(ExtensionInfo *extinfo) @@ -1164,7 +1165,7 @@ selectDumpableExtension(ExtensionInfo *extinfo) if (binary_upgrade && extinfo->dobj.catId.oid < (Oid) FirstNormalObjectId) extinfo->dobj.dump = false; else - extinfo->dobj.dump = true; + extinfo->dobj.dump = include_everything; } /* -- 2.40.0