By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Disabling Autocommit

P: 44
Hello,

Quoting postgresql documentation:

"13.4.1. Disable Autocommit

Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the end. Some client libraries may do this behind your back, in which case you need to make sure the library does it when you want it done.) [....] "

In my opinion the documentation doesn´t seem to be very assertive in relation to this matter. So i just ask someone to confirm if that is really the way to disable autocommit.

Best Regards
Apr 24 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
Hello,

Quoting postgresql documentation:

"13.4.1. Disable Autocommit

Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the end. Some client libraries may do this behind your back, in which case you need to make sure the library does it when you want it done.) [....] "

In my opinion the documentation doesn´t seem to be very assertive in relation to this matter. So i just ask someone to confirm if that is really the way to disable autocommit.

Best Regards
Transactions are a way to disable autocommit and do one after all queries. Have you got any doubts?
May 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.