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?"
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? |