From: | "Jim Wilson" <jimw(at)kelcomaine(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Commit Transaction Command |
Date: | 2004-08-06 01:44:05 |
Message-ID: | twig.1091756645.73366@kelcomaine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Uwe C. Schroeder | 2004-08-06 03:49:20 | Re: pdql, pg_dump, and pg_restore |
Previous Message | amir | 2004-08-06 00:41:37 | getting dead locks with 2 functions |