Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbdc5400

Browse files
committed
Fix breakages of hot standby regression test.
This commit changes HS regression test so that it usesREPEATABLE READ transaction instead of SERIALIZABLE onebecause SERIALIZABLE transaction isolation level is notavailable in HS. Also this commit fixes VACUUM/ANALYZElabel mixup.This was fixed in HEAD (commit2985e16), but it shouldhave been back-patched to 9.1 which had introduced SSIand forbidden SERIALIZABLE transaction in HS.Amit Langote
1 parent4fb6478 commitbdc5400

File tree

3 files changed

+3
-3
lines changed

3 files changed

+3
-3
lines changed

‎src/test/regress/expected/hs_standby_allowed.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,7 +49,7 @@ select count(*) as should_be_1 from hs1;
4949
(1 row)
5050

5151
end;
52-
begin transaction isolation levelserializable;
52+
begin transaction isolation levelrepeatable read;
5353
select count(*) as should_be_1 from hs1;
5454
should_be_1
5555
-------------

‎src/test/regress/expected/hs_standby_disallowed.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -124,7 +124,7 @@ unlisten *;
124124
ERROR: cannot execute UNLISTEN during recovery
125125
-- disallowed commands
126126
ANALYZE hs1;
127-
ERROR: cannot executeVACUUM during recovery
127+
ERROR: cannot executeANALYZE during recovery
128128
VACUUM hs2;
129129
ERROR: cannot execute VACUUM during recovery
130130
CLUSTER hs2 using hs1_pkey;

‎src/test/regress/sql/hs_standby_allowed.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -28,7 +28,7 @@ begin transaction read only;
2828
selectcount(*)as should_be_1from hs1;
2929
end;
3030

31-
begin transaction isolation levelserializable;
31+
begin transaction isolation levelrepeatable read;
3232
selectcount(*)as should_be_1from hs1;
3333
selectcount(*)as should_be_1from hs1;
3434
selectcount(*)as should_be_1from hs1;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp