More detailed error logging?

CSN wrote:

Is it possible to have the database name, datetime,
and maybe even the query itself show up in pgsql's
error log?

Plenty of options to log all sorts of info. See the manuals chapter
"16.4.6. Error Reporting and Logging" for details.

You can even increase detail settings in one particular connection using
SET ...

--
Richard Huxton
Archonet Ltd

check out
http://www.postgresql.org/docs/8.0/static/runtime-config.html

there are a couple of logging parameters.... which can log almost everything u want :)

Regards
Himanshu

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com