☰

在 psql 中强制事务

tag-icon • tag-icon psql
在 psql 中强制事务

当我使用 psql 控制台时，是否可以强制在事务中运行任何插入/更新/删除操作？还是我始终必须明确地以“BEGIN”开头每个命令？

答案1

似乎有一个我不知道的 AUTOCOMMIT 功能：

AUTOCOMMIT
When on (the default), each SQL command is automatically committed upon 
successful completion. To postpone commit in this mode, you must enter a 
BEGIN or START TRANSACTION SQL command. When off or unset, SQL commands are 
not committed until you explicitly issue COMMIT or END. The autocommit-off 
mode works by issuing an implicit BEGIN for you, just before any command 
that is not already in a transaction block and is not itself a BEGIN or 
other transaction-control command, nor a command that cannot be executed 
inside a transaction block (such as VACUUM).

Note: The autocommit-on mode is PostgreSQL's traditional behavior, but 
autocommit-off is closer to the SQL spec. If you prefer autocommit-off, you 
might wish to set it in the system-wide psqlrc file or your ~/.psqlrc file

相关内容