AUTOCOMMIT自动提交该参数要大写才能生效，否则即使小写autocommit改为off，但小写的autocommit并不生效

最新推荐文章于 2025-02-16 18:05:46 发布

原创最新推荐文章于 2025-02-16 18:05:46 发布 · 860 阅读

1 ·

CC 4.0 BY-SA版权

Highgo DB 专栏收录该内容

171 篇文章

订阅专栏

本文介绍了HighGo数据库3.1.4版本中自动提交功能的设置方法，包括使用大小写敏感的命令来更改自动提交状态，并展示了如何通过不同命令验证设置是否生效。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

highgo=# \! cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)

highgo=# select version();
version
------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)

highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# \echo :AUTOCOMMIT
on
highgo=# \set autocommit off --此时执行后\echo :autocommit显示为on；此时标记为自定义变量autocommit
highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# \echo :AUTOCOMMIT
on
highgo=# \set AUTOCOMMIT off ---AUTOCOMMIT要完全大写才能生效
highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# \echo :AUTOCOMMIT
off

使用show命令是查询数据库中的参数值，大小写效果一样：
highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# show AUTOCOMMIT;
autocommit
------------
on
(1 row)

highgo=# set AUTOCOMMIT TO on;
SET
highgo=# set AUTOCOMMIT TO oFF;
错误: SET AUTOCOMMIT TO OFF 不再被支持
highgo=# set AUTOCOMMIT TO off;
错误: SET AUTOCOMMIT TO OFF 不再被支持
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
highgo=# select version();
version
------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)

highgo=# \set autocommit on
highgo=# \echo :autocommit
on
highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# \set autocommit off --此时执行后\echo :autocommit显示为OFF
highgo=# show autocommit;
autocommit
------------
on -->pg中此处show的结果不显示修改后的值（显示默认值on），需要使用如下echo命令
(1 row)

highgo=# \echo :autocommit
off

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
highgo=# \echo :AUTOCOMMIT
on
highgo=# \set autocommit off
highgo=# show autocommit;
autocommit
------------
on
(1 row)

highgo=# \echo :AUTOCOMMIT
on
highgo=# \echo :autocommit
off
highgo=# SELECT * FROM TEST;
id | name
----+------
3 |
4 |
(2 rows)

highgo=# insert into test values (5);
INSERT 0 1
highgo=# SELECT * FROM TEST;
id | name
----+------
3 |
4 |
5 |
(3 rows)

highgo=# \echo :autocommit --此处虽然小写autocommit的值改成了off，但并不生效；实际会话中还是为ON
off
highgo=# \echo :AUTOCOMMIT
on