Re: BUG #14315: pg_dump --no-tablespaces doesn't do it's job when --create specified - Mailing list pgsql-bugs

abcz2.uprola@gmail.com writes:
> But I noticed that --no-tablespaces doesn't change --create option to not
> include tablespaces:

>  $ pg_dump -C --schema-only -U postgres -h test --no-tablespaces -d
> wp_analytics | grep "CREATE DATABASE"
> CREATE DATABASE wp_analytics WITH TEMPLATE = template0 ENCODING = 'UTF8'
> LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' TABLESPACE =
> wp_tblspc;

> I think that it is a bug.

Yeah, I think you're right, especially since the corresponding code in
pg_dumpall does suppress the TABLESPACE clause with --no-tablespaces.

            regards, tom lane