Re: Commit Transaction Command
От | Pierre-Frédéric Caillaud |
---|---|
Тема | Re: Commit Transaction Command |
Дата | |
Msg-id | opscaujmwocq72hf@musicbox обсуждение исходный текст |
Ответ на | Commit Transaction Command ("Jim Wilson" <jimw@kelcomaine.com>) |
Список | 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 по дате отправления: