Commit282713a

committed

Make the regression tests safe for TOAST.

1 parent6d1ae0c commit282713aCopy full SHA for 282713a

File tree

-8

lines changed

-8

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,11 +1,12 @@`
`1`	`1`	`VACUUM;`
`2`	`2`	`--`
`3`	`3`	`-- sanity check, if we don't have indices the test will take years to`
`4`		`--- complete.`
	`4`	`+-- complete. But skip TOAST relations since they will have varying`
	`5`	`+-- names depending on the current OID counter.`
`5`	`6`	`--`
`6`	`7`	`SELECT relname, relhasindex`
`7`	`8`	`FROM pg_class`
`8`		`- WHERE relhasindex`
	`9`	`+ WHERE relhasindex AND relkind != 't'`
`9`	`10`	`ORDER BY relname;`
`10`	`11`	`relname \| relhasindex`
`11`	`12`	`---------------------+-------------`

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -111,8 +111,7 @@ WHERE p1.typsend = p2.oid AND p1.typtype = 'b' AND`
`111`	`111`	`-- Look for illegal values in pg_class fields`
`112`	`112`	`SELECT p1.oid, p1.relname`
`113`	`113`	`FROM pg_class as p1`
`114`		`-WHERE (p1.relkind != 'r' AND p1.relkind != 'i' AND`
`115`		`- p1.relkind != 's' AND p1.relkind != 'S');`
	`114`	`+WHERE p1.relkind NOT IN ('r', 'i', 's', 'S', 't');`
`116`	`115`	`oid \| relname`
`117`	`116`	`-----+---------`
`118`	`117`	`(0 rows)`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -2,10 +2,11 @@`
`2`	`2`	`VACUUM;`
`3`	`3`	`--`
`4`	`4`	`-- sanity check, if we don't have indices the test will take years to`
`5`		`--- complete.`
	`5`	`+-- complete. But skip TOAST relations since they will have varying`
	`6`	`+-- names depending on the current OID counter.`
`6`	`7`	`--`
`7`	`8`	`SELECT relname, relhasindex`
`8`	`9`	`FROM pg_class`
`9`		`-WHERE relhasindex`
	`10`	`+WHERE relhasindexAND relkind!='t'`
`10`	`11`	`ORDER BY relname;`
`11`	`12`

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -99,8 +99,7 @@ WHERE p1.typsend = p2.oid AND p1.typtype = 'b' AND`
`99`	`99`
`100`	`100`	`SELECTp1.oid,p1.relname`
`101`	`101`	`FROM pg_classas p1`
`102`		`-WHERE (p1.relkind!='r'ANDp1.relkind!='i'AND`
`103`		`-p1.relkind!='s'ANDp1.relkind!='S');`
	`102`	`+WHEREp1.relkind NOTIN ('r','i','s','S','t');`
`104`	`103`
`105`	`104`	`-- Indexes should have an access method, others not.`
`106`	`105`

Comments

(0)