Re: Commit Transaction Command

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Jim Wilson <jimw(at)kelcomaine(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Commit Transaction Command
Date: 2004-08-06 18:32:20
Message-ID: 20040806183220.GA5167@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-08-06 18:55:50 Re: Trying to use GIST indexes again
Previous Message Scott Marlowe 2004-08-06 18:27:47 Re: Postgres and Tools Intro?