Allow using named with hold cursors in autocommit
No implicit transaction on named cursor close

Also, don't start an implicit transaction when fetching with
named with hold cursor, since it already returns results
from a previously committed transaction.