[GENERAL] autocommit and transactions

[Sally Sally]

Using perl DBI I recently read that if autocommit is turned on, it does a 
commit after every transaction. I wanted to confirm if this also applies to 
select statements.
When I'm loading data, I need to do a select before inserting a new row and 
I don't want to commit after the select because it's unnecessary. So I am 
thinking of turning off the autocommit. Any thoughts?
Thanks
Sally


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html