Commit2985e16

committed

regression test: fix hot standby tests by using repeatable read

Serializable transactions won't work on a Hot Standby. Also fixVACUUM/ANALYZE label mixup.Patch by Martín Marqués

1 parent7ec7378 commit2985e16Copy full SHA for 2985e16

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -49,7 +49,7 @@ select count(*) as should_be_1 from hs1;`
`49`	`49`	`(1 row)`
`50`	`50`
`51`	`51`	`end;`
`52`		`-begin transaction isolation levelserializable;`
	`52`	`+begin transaction isolation levelrepeatable read;`
`53`	`53`	`select count(*) as should_be_1 from hs1;`
`54`	`54`	`should_be_1`
`55`	`55`	`-------------`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -124,7 +124,7 @@ unlisten *;`
`124`	`124`	`ERROR: cannot execute UNLISTEN during recovery`
`125`	`125`	`-- disallowed commands`
`126`	`126`	`ANALYZE hs1;`
`127`		`-ERROR: cannot executeVACUUM during recovery`
	`127`	`+ERROR: cannot executeANALYZE during recovery`
`128`	`128`	`VACUUM hs2;`
`129`	`129`	`ERROR: cannot execute VACUUM during recovery`
`130`	`130`	`CLUSTER hs2 using hs1_pkey;`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -28,7 +28,7 @@ begin transaction read only;`
`28`	`28`	`selectcount(*)as should_be_1from hs1;`
`29`	`29`	`end;`
`30`	`30`
`31`		`-begin transaction isolation levelserializable;`
	`31`	`+begin transaction isolation levelrepeatable read;`
`32`	`32`	`selectcount(*)as should_be_1from hs1;`
`33`	`33`	`selectcount(*)as should_be_1from hs1;`
`34`	`34`	`selectcount(*)as should_be_1from hs1;`

Comments

(0)