terminal1.txt

text/plain

Download

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