Re: pgsql: Fix tablespace handling for partitioned indexes

On Sun, 4 Nov 2018 at 05:33, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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