0

Let's say I have following code:

begin;
set autocommit = 1;
update tbl1 set col1 = 1;
update tbl1 set col1 = 2;
commit;

What would be the difference if autocommit (line 2) was set to 0?

  • 1
    set autocommit = 1; does nothing, it is ignored on the server (it has actually been removed in the upcoming version 9.5) – a_horse_with_no_name Dec 21 '15 at 18:59
  • Ok, and what about set autocommit = 0? Does it change anything? – user606521 Dec 21 '15 at 21:17
  • 1
    As I said: set autocommit is ignored on the server. It has been removed in 9.5 – a_horse_with_no_name Dec 21 '15 at 22:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.