postgresql事务隔离级别如何查看以及设置
1、查看数据库事务隔离级别SELECT name, setting FROM pg_settings WHERE name ='default_transaction_isolation';或SELECT current_setting('default_transaction_isolation');2、设置全局事务隔离级别方法一:修改postgresql.conf文件中的default_tra
1、查看数据库事务隔离级别
SELECT name, setting FROM pg_settings WHERE name ='default_transaction_isolation';
或
SELECT current_setting('default_transaction_isolation');
2、设置全局事务隔离级别
方法一:修改postgresql.conf文件中的default_transaction_isolation
方法二:alter system set default_transaction_isolation to 'REPEATABLE READ';
3、设置当前会话事务隔离级别
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
设置当前事务的事务隔离级别
START TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
或:
BEGIN ISOLATION LEVEL READ UNCOMMITTED READ WRITE;
原文链接:https://blog.csdn.net/weixin_42500720/article/details/112166601
更多推荐
所有评论(0)