Native partitioning tablespace inheritance

Just had someone report that pg_partman wasn't handling tablespaces for
native partitioning.

https://github.com/keithf4/pg_partman/issues/212

I'd assumed that that was a property that was being inherited from the
parent table, but apparently the TABLESPACE flag to CREATE TABLE is
completely ignored for the parent table. I know the documentation states
that you can set the tablespace per child table, but accepting the flag on
the parent and completely ignoring it seems rather misleading to me.

keith(at)keith=# CREATE TABLE XXXX(YYYYYY TIMESTAMP NOT NULL) PARTITION BY
RANGE (YYYYYY ) TABLESPACE mytablespace;
CREATE TABLE
Time: 11.569 ms
keith(at)keith=# \d+ xxxx;
Table "public.xxxx"
Column | Type | Collation | Nullable | Default |
Storage | Stats target | Description
--------+-----------------------------+-----------+----------+---------+---------+--------------+-------------
yyyyyy | timestamp without time zone | | not null | |
plain | |
Partition key: RANGE (yyyyyy)

keith(at)keith=# select relname, reltablespace from pg_class where relname =
'xxxx';
relname | reltablespace
---------+---------------
xxxx | 0
(1 row)

Any chance of this being an inheritable property that can simply be
overridden if the TABLESPACE flag is set when creating a child table? If
it's not set, just set the tablespace to whatever was set for the parent.

For now, partman is going to have to rely on the template table option to
handle this the same way it does for indexes right now.

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com