Commited02b35

authored

Merge pull request#556 from postgrespro/PBCKP-120

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

2 parents4728756 +0b8cf41 commited02b35Copy full SHA for ed02b35

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
`@@ -38,6 +38,15 @@ def test_checkdb_amcheck_only_sanity(self):`
`38`	`38`	`node.safe_psql(`
`39`	`39`	`"postgres",`
`40`	`40`	`"create index on t_heap(id)")`
	`41`	`+`
	`42`	`+node.safe_psql(`
	`43`	`+"postgres",`
	`44`	`+"create table idxpart (a int) "`
	`45`	`+"partition by range (a)")`
	`46`	`+`
	`47`	`+node.safe_psql(`
	`48`	`+"postgres",`
	`49`	`+"create index on idxpart(a)")`
`41`	`50`
`42`	`51`	`try:`
`43`	`52`	`node.safe_psql(`

Comments

(0)