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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
