Thread: Am I in intransaction or in autocommit mode?
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... Thanks for your help: dd ps: in my prev. mail I asked this too, but in another context... possible this subject is better for this question.
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=*# Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
Hi!
2009.06.29. 15:34 keltezéssel, A. Kretschmer írta:
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
2009.06.29. 15:34 keltezéssel, A. Kretschmer írta:
Yes, warning... Hmmm... As I see no way to dispose this warning (except psql)...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=*#
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
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... > > Thanks for your help: > dd > You can set client_min_messages: test=# test=# show client_min_messages; client_min_messages --------------------- notice (1 row) test=*# begin; WARNING: there is already a transaction in progress BEGIN test=*# begin; WARNING: there is already a transaction in progress BEGIN test=*# begin; WARNING: there is already a transaction in progress BEGIN test=*# set client_min_messages=error; SET test=*# begin; BEGIN test=*# begin; BEGIN test=*# Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net