Re: Getting a error on creating a partition table index 12.2.

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