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@xxxxxxxx>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
