Back out another part of the original change: we need to get a snapshot when positioning a cursor, even if it is going to auto-commit.