Content-Length: 312456 | pFad | http://github.com/postgrespro/postgres_cluster/commit/de3e8e1a0ec3869667518946e0ec4045dc7520bb

CE closer look at serializable lock · postgrespro/postgres_cluster@de3e8e1 · GitHub
Skip to content

Commit de3e8e1

Browse files
committed
closer look at serializable lock
1 parent 39f73f5 commit de3e8e1

File tree

2 files changed

+23
-2
lines changed

2 files changed

+23
-2
lines changed

runtest.sh

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -24,9 +24,9 @@ sleep 3
2424

2525
cd src/test/regress
2626

27-
./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./parallel_schedule --use-existing
27+
# ./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./parallel_schedule --use-existing
2828

29-
# ./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./serial_schedule --use-existing
29+
./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./serial_schedule --use-existing
3030

3131
cd ../../..
3232

src/test/regress/sql/boolean.sql

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,24 @@
1+
CREATE TABLE serializable_update_tab (
2+
id int,
3+
filler text,
4+
description text
5+
);
6+
CREATE TABLE writetest (a int);
7+
8+
9+
BEGIN;
10+
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
11+
UPDATE serializable_update_tab SET description = 'no no', id = 1 WHERE id = 1;
12+
COMMIT;
13+
14+
15+
BEGIN;
16+
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ ONLY, DEFERRABLE; -- ok
17+
SELECT * FROM writetest; -- ok
18+
SET TRANSACTION READ WRITE; --fail
19+
COMMIT;
20+
21+
122
--
223
-- BOOLEAN
324
--

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/de3e8e1a0ec3869667518946e0ec4045dc7520bb

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy