Skip site navigation (1) Skip section navigation (2)

Re: Db and schema names in logged errors

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Db and schema names in logged errors
Date: 2005-07-12 15:49:04
Message-ID: 1121183344l.2248l.0l@mofo (view raw or flat)
Thread:
Lists: pgsql-general
On 07/12/2005 09:15:20 AM, Michael Fuhr wrote:
> On Mon, Jul 11, 2005 at 07:43:48PM +0000, Karl O. Pinc wrote:
> > Is there any way to get the DB and schema name into
> > error messages, particularly when the errors
> > are logged?
> 
> To see how logging can be configured, refer to "Error Reporting and
> Logging" in the "Server Run-time Environment" chapter of the
> documentation.  If you're using 8.0 then you might be interested
> in the log_line_prefix setting.
> 
> http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING

Thanks.  Don't know how I missed that.  I swear I looked.

Would be nice if there was a way to put the current schema
into the log prefix.

Karl <kop(at)meme(dot)com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


In response to

pgsql-general by date

Next:From: Harry MantheakisDate: 2005-07-12 15:56:41
Subject: Japanese words not distinguished
Previous:From: Adam O'TooleDate: 2005-07-12 15:47:57
Subject: INSERT INTO from a SELECT query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group