On Mon, 15 Dec 2003, Hardy Merrill wrote: > Paul, you normally don't care about committing or rolling > back unless you're actually updating the database by doing > either an INSERT or an UPDATE. When you're just doing > SELECT and fetches you really don't care about transaction > processing. If you want to use eval and $@ to trap errors > with fetches that's fine, but no need to have the rollback > in the if ($@).
Agreed, but if you have autocommit turned off you should still commit/rollback or somehow end the transaction at some point. Think about a long running process that has autocommit turned off & only does selects but has a transction isolation level of repeatable read or serializable insead of read commited. Rudy
