Re: Am I in intransaction or in autocommit mode?

Hi!

2009.06.29. 15:34 keltezéssel, A. Kretschmer írta:
> In response to durumdara :
>
>> Hi!
>>
>> Can I check with something that I'm in "in-transaction" or in autocommit
>> mode?
>> I wanna avoid the notices I got when I'm also in mode I need...
>>
>> For example:
>> "begin"
>> "begin" --- error notice...
>>
>
> Warning, not error.
>
> In psql, you can set the PROMPT:
>
> \set PROMPT1 '%/%R%x%# '
>
> test=# begin;
> BEGIN
> test=*#
>
Yes, warning... Hmmm... As I see no way to dispose this warning (except
psql)...

This is distrubing me a little, because if I use pre and post "rollback"
to surely release resources/transactions, and then my Pylons log can
full with warnings caused by double "begins" ("begin; rollback;"). I do
not check I'm in which transaction mode....

Thanks for your help:
dd