Re: Commit Transaction Command - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Commit Transaction Command
Date
Msg-id 20040806183220.GA5167@dcc.uchile.cl
Whole thread Raw
In response to Commit Transaction Command  ("Jim Wilson" <jimw@kelcomaine.com>)
List pgsql-general
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?"


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Postgres and Tools Intro?
Next
From: Alvaro Herrera
Date:
Subject: Re: Trying to use GIST indexes again