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? I'd like to be able to distinguish
> errors coming from the test databases from those
> coming from the live databases.
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
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
