Commit4251751

Sofia Kopikova

committed

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

Tags: pg_probackup

1 parentacc8edc commit4251751Copy full SHA for 4251751

File tree

-3

lines changed

-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'::char "`
`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'::char "`
	`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",`

Comments

(0)