Commitb036982

committed

psql: display tablespace for partitioned indexes

Nothing was shown previously.

1 parentfb9c475 commitb036982Copy full SHA for b036982

File tree

+11

-1

lines changed

+11

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3306,7 +3306,8 @@ add_tablespace_footer(printTableContent *const cont, char relkind,`
`3306`	`3306`	`if (relkind==RELKIND_RELATION\|\|`
`3307`	`3307`	`relkind==RELKIND_MATVIEW\|\|`
`3308`	`3308`	`relkind==RELKIND_INDEX\|\|`
`3309`		`-relkind==RELKIND_PARTITIONED_TABLE)`
	`3309`	`+relkind==RELKIND_PARTITIONED_TABLE\|\|`
	`3310`	`+relkind==RELKIND_PARTITIONED_INDEX)`
`3310`	`3311`	`{`
`3311`	`3312`	`/*`
`3312`	`3313`	`* We ignore the database default tablespace so that users not using`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -63,6 +63,7 @@ CREATE INDEX part_a_idx ON testschema.part (a) TABLESPACE regress_tblspace;`
`63`	`63`	`CREATE TABLE testschema.part2 PARTITION OF testschema.part FOR VALUES IN (2);`
`64`	`64`	`SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c`
`65`	`65`	`where c.reltablespace = t.oid AND c.relname LIKE 'part%_idx';`
	`66`	`+\d testschema.part_a_idx`
`66`	`67`
`67`	`68`	`-- check that default_tablespace doesn't affect ALTER TABLE index rebuilds`
`68`	`69`	`CREATE TABLE testschema.test_default_tab(id bigint) TABLESPACE regress_tblspace;`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -94,6 +94,14 @@ SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c`
`94`	`94`	`part_a_idx \| regress_tblspace`
`95`	`95`	`(3 rows)`
`96`	`96`
	`97`	`+\d testschema.part_a_idx`
	`98`	`+Partitioned index "testschema.part_a_idx"`
	`99`	`+ Column \| Type \| Key? \| Definition`
	`100`	`+--------+---------+------+------------`
	`101`	`+ a \| integer \| yes \| a`
	`102`	`+btree, for table "testschema.part"`
	`103`	`+Tablespace: "regress_tblspace"`
	`104`	`+`
`97`	`105`	`-- check that default_tablespace doesn't affect ALTER TABLE index rebuilds`
`98`	`106`	`CREATE TABLE testschema.test_default_tab(id bigint) TABLESPACE regress_tblspace;`
`99`	`107`	`INSERT INTO testschema.test_default_tab VALUES (1);`

Comments

(0)