Re: Should changing AutoCommit issue BEGIN and COMMIT?
Steve Haslam <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
Bill Moseley wrote: > 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. > > Could someone clarify? > > In testing changing AutoCommit does not issue and BEGIN or COMMIT. > IIRC issuing "begin work" to PostgreSQL may have undesirable side-effects such as fixing the value of current_timestamp for the duration of the transaction. So maybe it delays "begin work" until some other statement is being executed? It was quite a long time back that I encountered this... As you can probably guess, I haven't tested it :D SRH