Postgres LOG and NOTICE info..

From: "Twist" <vchris(at)club-internet(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres LOG and NOTICE info..
Date: 2001-08-27 17:08:09
Message-ID: 9mdnrh$33l$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

im using a jdbc connection to access postgres and somehow once i manage
transaction by myself i got some:

NOTICE: BEGIN: already a transaction in progress
NOTICE: COMMIT: no transaction

doing :

conn = ds.getConnection();
try
{
conn.setAutoCommit(false);
...
conn.commit();
}
catch(Exception e) {conn.rollback();}
finally
{
conn.setAutoCommit(true);
conn.close();
}

some questions come to my mind :

Why can i have those notices since i always commit or rollback a transaction
and i left the connection in the pool in AutoCommit ? (i should ask that in
jdbc section may be)

How can i tell postgres to not log those notices ?
i have debug_level = 0 and i would like to have only true errors in my log

Thx in advance

Browse pgsql-admin by date

  From Date Subject
Next Message Yogesh Shahir 2001-08-27 17:45:02 Help request
Previous Message Peter Eisentraut 2001-08-24 23:59:36 Re: Fast load