Re: 12.1 Partitioned Table Creation Bug

On Wed, Jan 22, 2020 at 12:48 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Chris Drawater <Chris(dot)Drawater(at)viavisolutions(dot)com> writes:
> > geo=> create table junk ( a int, b int) PARTITION BY RANGE (a);
> > ERROR: cannot specify default tablespace for partitioned relations
>
> I'm guessing you've got default_tablespace set to something nonempty.
>
> I don't know why the decision was made to throw an error rather than
> silently ignoring the setting ...
>

Ignoring the setting seems to be what the documentation says we do:

https://www.postgresql.org/docs/12/sql-createtable.html

"For partitioned tables, since no storage is required for the table itself,
the tablespace specified overrides default_tablespace as the default
tablespace to use for any newly created partitions when no other tablespace
is explicitly specified."

So this seems like a regression in v12.

David J.