title: postgresql connection and setting autocommit off
body: <p>I am programming in perl and have an existing connection (progammatically) with my postgres database. After the connection is established, I do not control the connection code, I want to set autocommit to off. </p>
  
  <p>How does one do that? When I do it interactively, I do not see any changes. I \set autocommit off and then do an insert and I see the change. I do a rollback, I get there is no transaction exists.</p>
  
  <p>I want to set autocommit off, do my work and then commit. How does one accomplish that with an existing connection?</p>
  
  <p>Thanks
  Reza</p>