Commita5586a0

committed

Don't allow partitioned indexes in pg_global tablespace

1 parentefcb06f commita5586a0Copy full SHA for a5586a0

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -11070,6 +11070,12 @@ ATExecPartedIdxSetTableSpace(Relation rel, Oid newTableSpace)`
`11070`	`11070`
`11071`	`11071`	`Assert(rel->rd_rel->relkind==RELKIND_PARTITIONED_INDEX);`
`11072`	`11072`
	`11073`	`+/* Can't allow a non-shared relation in pg_global */`
	`11074`	`+if (newTableSpace==GLOBALTABLESPACE_OID)`
	`11075`	`+ereport(ERROR,`
	`11076`	`+(errcode(ERRCODE_INVALID_PARAMETER_VALUE),`
	`11077`	`+errmsg("only shared relations can be placed in pg_global tablespace")));`
	`11078`	`+`
`11073`	`11079`	`/*`
`11074`	`11080`	`* No work if no change in tablespace.`
`11075`	`11081`	`*/`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -101,6 +101,7 @@ CREATE UNIQUE INDEX anindex ON testschema.atable(column1);`
`101`	`101`
`102`	`102`	`ALTER TABLE testschema.atable SET TABLESPACE regress_tblspace;`
`103`	`103`	`ALTER INDEX testschema.anindex SET TABLESPACE regress_tblspace;`
	`104`	`+ALTER INDEX testschema.part_a_idx SET TABLESPACE pg_global;`
`104`	`105`	`ALTER INDEX testschema.part_a_idx SET TABLESPACE pg_default;`
`105`	`106`	`ALTER INDEX testschema.part_a_idx SET TABLESPACE regress_tblspace;`
`106`	`107`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -214,6 +214,8 @@ CREATE TABLE testschema.atable AS VALUES (1), (2);`
`214`	`214`	`CREATE UNIQUE INDEX anindex ON testschema.atable(column1);`
`215`	`215`	`ALTER TABLE testschema.atable SET TABLESPACE regress_tblspace;`
`216`	`216`	`ALTER INDEX testschema.anindex SET TABLESPACE regress_tblspace;`
	`217`	`+ALTER INDEX testschema.part_a_idx SET TABLESPACE pg_global;`
	`218`	`+ERROR: only shared relations can be placed in pg_global tablespace`
`217`	`219`	`ALTER INDEX testschema.part_a_idx SET TABLESPACE pg_default;`
`218`	`220`	`ALTER INDEX testschema.part_a_idx SET TABLESPACE regress_tblspace;`
`219`	`221`	`INSERT INTO testschema.atable VALUES(3);-- ok`

Comments

(0)