Re: Should changing AutoCommit issue BEGIN and COMMIT?
"Greg Sabino Mullane" <greg-738XdyZ4GzZWk0Htik3J/[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > By the way: how about a pointer to the new list in this auto-response and > a link on http://lists.cpan.org/. Thanks, I'll look into that. > I'm not clear what the intended behavior is suppose to be. But it > seems that changing AutoCommit from 1 to 0 should issue a BEGIN, and > from 0 to 1 a COMMIT from the docs below. Changing autocommit changes the mode, but does not necessarily issue an immediate command. If going from AutoCommit off to AutoCommit on, a commit will only be issued if you are already inside of a transaction. If you have not done anything yet, or if the last command was a commit or rollback, then no commit will be issued. If you are going from AutoCommit off to AutoCommit on, a begin will be issued only immediately *before* the first subsequent command is issued. This avoids having a transaction open needlessly. Hope that makes sense, if not, let the list know. And documentation patches are always welcome as well. :) - -- Greg Sabino Mullane greg-738XdyZ4GzZWk0Htik3J/[email protected] PGP Key: 0x14964AC8 200704152043 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFGIsgRvJuQZxSWSsgRA9ZaAJ9tNmRDja0E6sqHBmskzK72lQR3JACeNEDH n7ZsRN1szAw0ME8xadR7cLQ= =oYNn -----END PGP SIGNATURE-----