Re: pgsql: Fix tablespace handling for partitioned indexes

2018-11-23 Thread Alvaro Herrera
On 2018-Nov-23, David Rowley wrote: > A patch to fix is attached. Oops! Thanks. Pushed. I added a test line to verify that the error is thrown. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: pgsql: Fix tablespace handling for partitioned indexes

2018-11-22 Thread David Rowley
On Sun, 4 Nov 2018 at 05:33, Alvaro Herrera 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: o

pgsql: Fix tablespace handling for partitioned indexes

2018-11-03 Thread Alvaro Herrera
Fix tablespace handling for partitioned indexes When creating partitioned indexes, the tablespace was not being saved for the parent index. This meant that subsequently created partitions would not use the right tablespace for their indexes. ALTER INDEX SET TABLESPACE and ALTER INDEX ALL IN TABLE

pgsql: Fix tablespace handling for partitioned indexes

2018-11-03 Thread Alvaro Herrera
Fix tablespace handling for partitioned indexes When creating partitioned indexes, the tablespace was not being saved for the parent index. This meant that subsequently created partitions would not use the right tablespace for their indexes. ALTER INDEX SET TABLESPACE and ALTER INDEX ALL IN TABLE