psql (9.2devel) Type "help" for help. postgres=# begin transaction; BEGIN postgres=# set iso postgres=# set trans transaction transaction_deferrable transaction_isolation transaction_read_only transform_null_equals postgres=# set transaction isolation level read only; ERROR: syntax error at or near "only" LINE 1: set transaction isolation level read only; ^ postgres=# set transaction isolation level readonly; ERROR: syntax error at or near "readonly" LINE 1: set transaction isolation level readonly; ^ postgres=# set transaction ISOLATION LEVEL READ postgres=# set transaction ISOLATION LEVEL READ REPEATABLE SERIALIZABLE postgres=# set transaction ISOLATION LEVEL READ COMMITTED UNCOMMITTED postgres=# set transaction ISOLATION LEVEL READ committed; ERROR: current transaction is aborted, commands ignored until end of transaction block postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# set transaction ISOLATION LEVEL READ committed; SET postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# select 1; ?column? ---------- 1 (1 row) postgres=# set transaction ISOLATION LEVEL READ committed; SET postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# set transaction ISOLATION LEVEL serializable;; SET postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# select 1; ?column? ---------- 1 (1 row) postgres=# set transaction ISOLATION LEVEL serializable;; ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query postgres=# rollback; ROLLBACK (reverse-i-search)`be': select count(*) from clustermem^Crs ; postgres=# begin transaction; BEGIN postgres=# set transaction ISOLATION LEVEL repeatable read; SET postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# set transaction ISOLATION LEVEL repeatable read; SET postgres=# rollback; ROLLBACK postgres=# begin transaction; BEGIN postgres=# select 1; ?column? ---------- 1 (1 row) postgres=# set transaction ISOLATION LEVEL repeatable read; ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query postgres=# set transaction ISOLATION LEVEL ; READ REPEATABLE SERIALIZABLE postgres=# rollback; ROLLBACK postgres=# begin TRANSACTION ; BEGIN postgres=# set transaction snapshot '000002C8-1'; ERROR: SET TRANSACTION SNAPSHOT must be called before any query postgres=# rollback; ROLLBACK postgres=# begin TRANSACTION ; BEGIN postgres=# set transaction snapshot '000002C9-1'; ERROR: a snapshot-importing transaction must have isolation level SERIALIZABLE or REPEATABLE READ postgres=# rollback; ROLLBACK postgres=# begin TRANSACTION ; BEGIN postgres=# set transaction ISOLATION LEVEL repeatable read; SET postgres=# set transaction snapshot '000002C9-1'; SET postgres=# rollback; ROLLBACK postgres=# begin TRANSACTION ; BEGIN postgres=# set transaction snapshot '000002CA-1'; ERROR: a snapshot-importing transaction must have isolation level SERIALIZABLE or REPEATABLE READ postgres=# rollack; ERROR: syntax error at or near "rollack" LINE 1: rollack; ^ postgres=# rollback; ROLLBACK postgres=# begin TRANSACTION ; BEGIN postgres=# set transaction ISOLATION LEVEL repeatable read; SET postgres=# set transaction snapshot '000002CA-1'; ERROR: invalid snapshot identifier "000002CA-1" postgres=# \q