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:
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
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