Commit09d09b9

committed

Add a regression test for ALTER SET TABLESPACE; this is a whole separate

code path in tablecmds.c that wasn't exercised at all before.

1 parentcac2d91 commit09d09b9Copy full SHA for 09d09b9

File tree

+26

-0

lines changed

+26

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -28,6 +28,17 @@ CREATE INDEX foo_idx on testschema.foo(i) TABLESPACE testspace;`
`28`	`28`	`SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c`
`29`	`29`	`where c.reltablespace = t.oid AND c.relname = 'foo_idx';`
`30`	`30`
	`31`	`+-- let's try moving a table from one place to another`
	`32`	`+CREATE TABLE testschema.atable AS VALUES (1), (2);`
	`33`	`+CREATE UNIQUE INDEX anindex ON testschema.atable(column1);`
	`34`	`+`
	`35`	`+ALTER TABLE testschema.atable SET TABLESPACE testspace;`
	`36`	`+ALTER INDEX testschema.anindex SET TABLESPACE testspace;`
	`37`	`+`
	`38`	`+INSERT INTO testschema.atable VALUES(3);-- ok`
	`39`	`+INSERT INTO testschema.atable VALUES(1);-- fail (checks index)`
	`40`	`+SELECT COUNT(*) FROM testschema.atable;-- checks heap`
	`41`	`+`
`31`	`42`	`-- Will fail with bad path`
`32`	`43`	`CREATE TABLESPACE badspace LOCATION '/no/such/location';`
`33`	`44`

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -41,6 +41,20 @@ SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c`
`41`	`41`	`foo_idx \| testspace`
`42`	`42`	`(1 row)`
`43`	`43`
	`44`	`+-- let's try moving a table from one place to another`
	`45`	`+CREATE TABLE testschema.atable AS VALUES (1), (2);`
	`46`	`+CREATE UNIQUE INDEX anindex ON testschema.atable(column1);`
	`47`	`+ALTER TABLE testschema.atable SET TABLESPACE testspace;`
	`48`	`+ALTER INDEX testschema.anindex SET TABLESPACE testspace;`
	`49`	`+INSERT INTO testschema.atable VALUES(3);-- ok`
	`50`	`+INSERT INTO testschema.atable VALUES(1);-- fail (checks index)`
	`51`	`+ERROR: duplicate key violates unique constraint "anindex"`
	`52`	`+SELECT COUNT(*) FROM testschema.atable;-- checks heap`
	`53`	`+ count`
	`54`	`+-------`
	`55`	`+ 3`
	`56`	`+(1 row)`
	`57`	`+`
`44`	`58`	`-- Will fail with bad path`
`45`	`59`	`CREATE TABLESPACE badspace LOCATION '/no/such/location';`
`46`	`60`	`ERROR: could not set permissions on directory "/no/such/location": No such file or directory`
`@@ -51,6 +65,7 @@ ERROR: tablespace "nosuchspace" does not exist`
`51`	`65`	`DROP TABLESPACE testspace;`
`52`	`66`	`ERROR: tablespace "testspace" is not empty`
`53`	`67`	`DROP SCHEMA testschema CASCADE;`
	`68`	`+NOTICE: drop cascades to table testschema.atable`
`54`	`69`	`NOTICE: drop cascades to table testschema.asexecute`
`55`	`70`	`NOTICE: drop cascades to table testschema.asselect`
`56`	`71`	`NOTICE: drop cascades to table testschema.foo`

Comments

(0)