diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-04-22 17:23:58 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-04-22 17:23:58 -0400 |
| commit | 2985e16031b61e9a428635e6860b3024570d3666 (patch) | |
| tree | 0c47f26d5f7646c4198b6945db30a0a0e4102a40 /src | |
| parent | 7ec73783d88a743799b0c262f1235f772497fb1d (diff) | |
| download | postgresql-2985e16031b61e9a428635e6860b3024570d3666.tar.gz postgresql-2985e16031b61e9a428635e6860b3024570d3666.zip | |
regression test: fix hot standby tests by using repeatable read
Serializable transactions won't work on a Hot Standby. Also fix
VACUUM/ANALYZE label mixup.
Patch by Martín Marqués
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/hs_standby_allowed.out | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/hs_standby_disallowed.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/hs_standby_allowed.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/hs_standby_allowed.out b/src/test/regress/expected/hs_standby_allowed.out index 1abe5f6fe94..c26c9822f63 100644 --- a/src/test/regress/expected/hs_standby_allowed.out +++ b/src/test/regress/expected/hs_standby_allowed.out @@ -49,7 +49,7 @@ select count(*) as should_be_1 from hs1; (1 row) end; -begin transaction isolation level serializable; +begin transaction isolation level repeatable read; select count(*) as should_be_1 from hs1; should_be_1 ------------- diff --git a/src/test/regress/expected/hs_standby_disallowed.out b/src/test/regress/expected/hs_standby_disallowed.out index e7f4835092f..bc117413ffd 100644 --- a/src/test/regress/expected/hs_standby_disallowed.out +++ b/src/test/regress/expected/hs_standby_disallowed.out @@ -124,7 +124,7 @@ unlisten *; ERROR: cannot execute UNLISTEN during recovery -- disallowed commands ANALYZE hs1; -ERROR: cannot execute VACUUM during recovery +ERROR: cannot execute ANALYZE during recovery VACUUM hs2; ERROR: cannot execute VACUUM during recovery CLUSTER hs2 using hs1_pkey; diff --git a/src/test/regress/sql/hs_standby_allowed.sql b/src/test/regress/sql/hs_standby_allowed.sql index 58e2c010d33..7fc22148cbc 100644 --- a/src/test/regress/sql/hs_standby_allowed.sql +++ b/src/test/regress/sql/hs_standby_allowed.sql @@ -28,7 +28,7 @@ begin transaction read only; select count(*) as should_be_1 from hs1; end; -begin transaction isolation level serializable; +begin transaction isolation level repeatable read; select count(*) as should_be_1 from hs1; select count(*) as should_be_1 from hs1; select count(*) as should_be_1 from hs1; |