Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux