pgsql: Don't print database's tablespace in pg_dump -C --no-tablespaces - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Don't print database's tablespace in pg_dump -C --no-tablespaces
Date
Msg-id E1bi0cg-0003bz-01@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Don't print database's tablespace in pg_dump -C --no-tablespaces output.

If the database has a non-default tablespace, we emitted a TABLESPACE
clause in the CREATE DATABASE command emitted by -C, even if
--no-tablespaces was also specified.  This seems wrong, and it's
inconsistent with what pg_dumpall does, so change it.  Per bug #14315
from Danylo Hlynskyi.

Back-patch to 9.5.  The bug is much older, but it'd be a more invasive
change before 9.5 because dumpDatabase() hasn't got an easy way to get
to the outputNoTablespaces flag.  Doesn't seem worth the work given
the lack of previous complaints.

Report: <20160908081953.1402.75347@wrigleys.postgresql.org>

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/142a110b312fa2d6bbc4eba4df196c35e0caf7bb

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Don't print database's tablespace in pg_dump -C --no-tablespaces
Next
From: Tom Lane
Date:
Subject: pgsql: Don't print database's tablespace in pg_dump -C --no-tablespaces