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 E1bi0cf-0003by-WE@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_6_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/a88cee90fdfb2c125d56cb08164ca9a9ca39a75d

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: Allow pg_dump to dump non-extension members of an extension-owne