cd src/test/regress

./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./parallel_schedule --use-existing

./pg_regress --inputdir=. --bindir='../../../tmp_install/bin' --dlpath=. --schedule=./serial_schedule --use-existing

cd ../../..

CREATETABLEserializable_update_tab (

idint,

fillertext,

descriptiontext

);

CREATETABLEwritetest (aint);

BEGIN;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

UPDATE serializable_update_tabSET description='no no', id=1WHERE id=1;

COMMIT;

BEGIN;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ ONLY, DEFERRABLE;-- ok

SELECT*FROM writetest;-- ok

SET TRANSACTION READ WRITE;--fail

COMMIT;