On 2020-Mar-05, Adrian Klaver wrote:
> The OP was wondering why it worked in 12.1 and not 12.2?
>
> I could not see any obvious reason for that, so:
>
> 1) There is a not obvious reason
>
> 2) It did not work in 12.1 either.
(2) is correct.
55469 12.1 9913=# show server_version;
server_version
────────────────
12.1
(1 fila)
55469 12.1 9913=# create index on p (a) tablespace pg_default;
ERROR: cannot specify default tablespace for partitioned relations
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services