PostgreSQL之ERROR: 25P02: current transaction is aborted

ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
复制

testdb=> \set AUTOCOMMIT off
testdb=> select * from test1;
ERROR:  relation "test1" does not exist
LINE 1: select * from test1;
                      ^
testdb=> select * from aaa;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
testdb=> rollback;
ROLLBACK
testdb=> select * from aaa;
 id | info | crt_time | c1
----+------+----------+----
(0 rows)
复制