Postgres LOG and NOTICE info..

Поиск
Список
Период
Сортировка
От Twist
Тема Postgres LOG and NOTICE info..
Дата
Msg-id 9mdnrh$33l$1@news.tht.net
обсуждение исходный текст
Список 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




В списке pgsql-admin по дате отправления:

Предыдущее
От: Arne Weiner
Дата:
Сообщение: Re: Postgres Startup trouble
Следующее
От: "guard"
Дата:
Сообщение: pg_dump -Z