On 2 Apr 2011, at 12:44, Thomas Kellerer wrote:
> Even after a plain SELECT you should issue a COMMIT (or ROLLBACK) to end the transaction that was implicitely started
withthe SELECT.
Sorry, but you're wrong about that. A statement that implicitly starts a transaction also implicitly COMMITs it.
Otherwisesingle UPDATE and INSERT statements outside of transaction blocks would not COMMIT, and they do.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4d983b2f651341263218540!