Re: Commit Transaction Command

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Commit Transaction Command
Дата
Msg-id 20040806183220.GA5167@dcc.uchile.cl
обсуждение исходный текст
Ответ на Commit Transaction Command  ("Jim Wilson" <jimw@kelcomaine.com>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Postgres and Tools Intro?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Trying to use GIST indexes again