Re: [GENERAL] Am I in intransaction or in autocommit mode?
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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
Re: [GENERAL] Am I in intransaction or in autocommit mode?
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general