Re: Unwanted Log Entries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Swinth <jswinth(at)atomicpc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unwanted Log Entries
Date: 2002-11-22 19:02:38
Message-ID: 26108.1037991758@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jon Swinth <jswinth(at)atomicpc(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-11-22 19:05:52 Re: database structure
Previous Message Tom Lane 2002-11-22 18:56:43 Re: Lack of use of indexes