Commitde38ce1

committed

Don't allow partitioned indexes in pg_global tablespace

1 parenta80dcac commitde38ce1Copy full SHA for de38ce1

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -10939,6 +10939,12 @@ ATExecPartedIdxSetTableSpace(Relation rel, Oid newTableSpace)`
`10939`	`10939`
`10940`	`10940`	`Assert(rel->rd_rel->relkind==RELKIND_PARTITIONED_INDEX);`
`10941`	`10941`
	`10942`	`+/* Can't allow a non-shared relation in pg_global */`
	`10943`	`+if (newTableSpace==GLOBALTABLESPACE_OID)`
	`10944`	`+ereport(ERROR,`
	`10945`	`+(errcode(ERRCODE_INVALID_PARAMETER_VALUE),`
	`10946`	`+errmsg("only shared relations can be placed in pg_global tablespace")));`
	`10947`	`+`
`10942`	`10948`	`/*`
`10943`	`10949`	`* No work if no change in tablespace.`
`10944`	`10950`	`*/`

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)