Re: Am I in intransaction or in autocommit mode?

[durumdara <durumdara@xxxxxxxxx>]

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