Re: Db and schema names in logged errors

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