Обсуждение: More detailed error logging?

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

Thanks,
CSN



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/

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

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