Commit Transaction Command

[Jim Wilson]

The debug logs seem a little confusing. On sending a query something like
this will show up:

DEBUG: StartTransactionCommand
LOG: query: select * from blah;
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand

This is with auto commit off. My first reaction on seeing this was the auto
commit setting must not work. Then I noticed that most things, even "begin"
and "commit" commands entered via the query interface in psql were wrapped
with the same "DEBUG" output. And finally I did some testing and found that
transactions did in fact work correctly.

I am hoping that someone can enlighten me as to what this DEBUG output
actually indicates.

Running version 7.3.5.

Thanks,

Jim Wilson
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Pierre-Frédéric Caillaud]

If you don't explicitly BEGIN, the interface (psql) will wrap every of
your commands in a transaction.

On Fri, 6 Aug 2004 01:44:05 -0000, Jim Wilson <ji**@kelcomaine.com> wrote:

The debug logs seem a little confusing. On sending a query something
like
this will show up:

DEBUG: StartTransactionCommand
LOG: query: select * from blah;
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand

This is with auto commit off. My first reaction on seeing this was the
auto
commit setting must not work. Then I noticed that most things, even
"begin"
and "commit" commands entered via the query interface in psql were
wrapped
with the same "DEBUG" output. And finally I did some testing and found
that
transactions did in fact work correctly.

I am hoping that someone can enlighten me as to what this DEBUG output
actually indicates.

Running version 7.3.5.

Thanks,

Jim Wilson
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Alvaro Herrera]

On Fri, Aug 06, 2004 at 01:44:05AM -0000, Jim Wilson wrote:

The debug logs seem a little confusing. On sending a query something like
this will show up:

DEBUG: StartTransactionCommand
LOG: query: select * from blah;
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand

The CommitTransactionCommand function actually means "stop processing
the command we just received". If said command was a COMMIT or
ROLLBACK, then it will also commit the transaction (resp. abort it). If
it wasn't, then the transaction will be kept open. So you have nothing
to worry about, short of a loglevel set up a little too high ;-)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html