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

abcz2(dot)uprola(at)gmail(dot)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