On Sun, 4 Nov 2018 at 05:33, Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote: > Fix tablespace handling for partitioned indexes
While working on something else, I noticed this: # create table listp (a int) partition by list(a); CREATE TABLE # create index on listp (a) tablespace pg_global; -- properly disallowed ERROR: only shared relations can be placed in pg_global tablespace # create index on listp (a); CREATE INDEX # alter index listp_a_idx set tablespace pg_global; -- should be disallowed ALTER INDEX # create table listp1 partition of listp for values in(1); ERROR: only shared relations can be placed in pg_global tablespace A patch to fix is attached. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
disallow_partitioned_indexes_from_being_put_in_pg_global.patch
Description: Binary data
