Re: Unwanted Log Entries - Mailing list pgsql-general

From Tom Lane
Subject Re: Unwanted Log Entries
Date
Msg-id 26108.1037991758@sss.pgh.pa.us
Whole thread Raw
In response to Unwanted Log Entries  (Jon Swinth <jswinth@atomicpc.com>)
Responses Re: Unwanted Log Entries
List pgsql-general
Jon Swinth <jswinth@atomicpc.com> writes:
> We are currently using PostgreSQL 7.2.2 in production with JBoss 3.0.3.  The
> DB is working to spec but the log is being filled with the following line
> over and over again:

> NOTICE:  TRANSACTION ISOLATION LEVEL is READ COMMITTED

This is presumably triggered by a "SHOW TRANSACTION ISOLATION LEVEL"
command somewhere in your client.  You could probably remove that
command.

In 7.3, SHOW commands don't generate log entries anymore, but that won't
help you today...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lack of use of indexes
Next
From: "scott.marlowe"
Date:
Subject: Re: database structure