Commit55238d5

Sofia Kopikova

committed

[PBCKP-120] skip partitioned indexes for checkdb --amcheck

Tags: pg_probackup

1 parentacc8edc commit55238d5Copy full SHA for 55238d5

File tree

+16

-3

lines changed

+16

-3

lines changed

Lines changed: 7 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -461,7 +461,9 @@ get_index_list(const char *dbname, bool first_db_with_amcheck,`
`461`	`461`	`"LEFT JOIN pg_catalog.pg_class cls ON idx.indexrelid=cls.oid "`
`462`	`462`	`"LEFT JOIN pg_catalog.pg_namespace nmspc ON cls.relnamespace=nmspc.oid "`
`463`	`463`	`"LEFT JOIN pg_catalog.pg_am am ON cls.relam=am.oid "`
`464`		`-"WHERE am.amname='btree' AND cls.relpersistence != 't' "`
	`464`	`+"WHERE am.amname='btree' "`
	`465`	`+"AND cls.relpersistence != 't' "`
	`466`	`+"AND cls.relkind != 'I' "`
`465`	`467`	`"ORDER BY nmspc.nspname DESC",`
`466`	`468`	`0,NULL);`
`467`	`469`	`}`
`@@ -473,8 +475,10 @@ get_index_list(const char *dbname, bool first_db_with_amcheck,`
`473`	`475`	`"LEFT JOIN pg_catalog.pg_class cls ON idx.indexrelid=cls.oid "`
`474`	`476`	`"LEFT JOIN pg_catalog.pg_namespace nmspc ON cls.relnamespace=nmspc.oid "`
`475`	`477`	`"LEFT JOIN pg_catalog.pg_am am ON cls.relam=am.oid "`
`476`		`-"WHERE am.amname='btree' AND cls.relpersistence != 't' AND "`
`477`		`-"(cls.reltablespace IN "`
	`478`	`+"WHERE am.amname='btree' "`
	`479`	`+"AND cls.relpersistence != 't' "`
	`480`	`+"AND cls.relkind != 'I' "`
	`481`	`+"AND (cls.reltablespace IN "`
`478`	`482`	`"(SELECT oid from pg_catalog.pg_tablespace where spcname <> 'pg_global') "`
`479`	`483`	`"OR cls.reltablespace = 0) "`
`480`	`484`	`"ORDER BY nmspc.nspname DESC",`

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -36,6 +36,15 @@ def test_checkdb_amcheck_only_sanity(self):`
`36`	`36`	`node.safe_psql(`
`37`	`37`	`"postgres",`
`38`	`38`	`"create index on t_heap(id)")`
	`39`	`+`
	`40`	`+node.safe_psql(`
	`41`	`+"postgres",`
	`42`	`+"create table idxpart (a int) "`
	`43`	`+"partition by range (a)")`
	`44`	`+`
	`45`	`+node.safe_psql(`
	`46`	`+"postgres",`
	`47`	`+"create index on idxpart(a)")`
`39`	`48`
`40`	`49`	`try:`
`41`	`50`	`node.safe_psql(`

Comments

(0)