Disabling Autocommit

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zeny
    New Member
    • Jul 2006
    • 44

    Disabling Autocommit

    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
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Originally posted by zeny
    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?

    Comment

    Working...