setting autocommit off in pgsql
Started by Antony Paulalmost 22 years ago3 messagesgeneral
Hi all
How to set autocommit off. I want transactions which requires explicit
commit and after commit a new transaction is started as in Oracle sql plus.
When using start transaction it requires to type start transaction every
time.
Antony Paul
Re: setting autocommit off in pgsql
Use BEGIN to open a transaction ( that's the difference to Oracle )
and COMMIT or ROLLBACK to close it.
Antony Paul schrieb:
Show quoted text
Hi all
How to set autocommit off. I want transactions which requires
explicit
commit and after commit a new transaction is started as in Oracle sql
plus.
When using start transaction it requires to type start transaction every
time.Antony Paul
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
