Re: Commit Transaction Command - Mailing list pgsql-general

From Pierre-Frédéric Caillaud
Subject Re: Commit Transaction Command
Date
Msg-id opscaujmwocq72hf@musicbox
Whole thread Raw
In response to Commit Transaction Command  ("Jim Wilson" <jimw@kelcomaine.com>)
List pgsql-general
    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 <jimw@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 majordomo@postgresql.org)
>



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Sequence Question DOH!
Next
From: Richard Huxton
Date:
Subject: Re: Data version idea (please discuss)