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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
