sql - 一个命令的交易

Question

如果在COMMIT之前，在一个事务中只发出一个命令，是否相当于完全省略事务？ (特别是在 Postgres 中)

Answer 1

是的，我引用他们的文档:

PostgreSQL actually treats every SQL statement as being executed within a transaction. If you do not issue a BEGIN command, then each individual statement has an implicit BEGIN and (if successful) COMMIT wrapped around it. A group of statements surrounded by BEGIN and COMMIT is sometimes called a transaction block.

在这里找到: http://www.postgresql.org/docs/8.3/static/tutorial-transactions.html