合 PG查看和设置事务的隔离级别
查看和设置PG的事务隔离级别
事务内容请参考:https://www.xmmup.com/pgzhongdeshiwu.html
PG默认的事务隔离级别为Read Committed。
数据库隔离级别
查看全局事务隔离级别
1 2 3 4 5 6 7 8 9 10 11 | postgres=# select current_setting('default_transaction_isolation'); current_setting ----------------- read committed (1 row) postgres=# SELECT name,setting FROM pg_settings WHERE name='default_transaction_isolation'; name | setting -------------------------------+---------------- default_transaction_isolation | read committed (1 row) |