Commit39314ef

committed

Minor fixes for reloptions tests

Follow-up to4b95cc1Author: Nikolay Shaplov <dhyan@nataraj.su>

1 parent8d90b4d commit39314efCopy full SHA for 39314ef

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -77,7 +77,7 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass;`
`77`	`77`	`ALTER TABLE reloptions_test RESET (autovacuum_enabled,`
`78`	`78`	`autovacuum_analyze_scale_factor);`
`79`	`79`	`SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND`
`80`		`-reloptions IS NULL;`
	`80`	`+reloptions IS NULL;`
`81`	`81`	`reloptions`
`82`	`82`	`------------`
`83`	`83`
`@@ -86,7 +86,7 @@ reloptions IS NULL;`
`86`	`86`	`-- RESET fails if a value is specified`
`87`	`87`	`ALTER TABLE reloptions_test RESET (fillfactor=12);`
`88`	`88`	`ERROR: RESET must not include values for parameters`
`89`		`--- The OIDS option is not stored`
	`89`	`+-- The OIDS option is not stored as reloption`
`90`	`90`	`DROP TABLE reloptions_test;`
`91`	`91`	`CREATE TABLE reloptions_test(i INT) WITH (fillfactor=20, oids=true);`
`92`	`92`	`SELECT reloptions, relhasoids FROM pg_class WHERE oid = 'reloptions_test'::regclass;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -47,12 +47,12 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass;`
`47`	`47`	`ALTERTABLE reloptions_test RESET (autovacuum_enabled,`
`48`	`48`	`autovacuum_analyze_scale_factor);`
`49`	`49`	`SELECT reloptionsFROM pg_classWHEREoid='reloptions_test'::regclassAND`
`50`		`-reloptions ISNULL;`
	`50`	`+reloptions ISNULL;`
`51`	`51`
`52`	`52`	`-- RESET fails if a value is specified`
`53`	`53`	`ALTERTABLE reloptions_test RESET (fillfactor=12);`
`54`	`54`
`55`		`--- The OIDS option is not stored`
	`55`	`+-- The OIDS option is not stored as reloption`
`56`	`56`	`DROPTABLE reloptions_test;`
`57`	`57`	`CREATETABLEreloptions_test(iINT) WITH (fillfactor=20, oids=true);`
`58`	`58`	`SELECT reloptions, relhasoidsFROM pg_classWHEREoid='reloptions_test'::regclass;`

Comments

(0)