Обсуждение: Error Logging with clusters

Hi,

I got a database cluster with multiple databases on
it. all with similar tables/indexes etc.

Now the question is, how to identify database x raised
error y (which gets logged in server logfile).

for e.g. below snip gets logged in server logfile,
which clearly tells dummy_id is not a column of
temp_table. however it doesn't say what database or
schema.

2003-07-29 12:13:14 ERROR:  No such attribute
temp_table.dummy_id

i have log_min_error_statement, server_min_messages to
its defaults which is error and notice respectively. I
tried log_statement=true, but that didn't help either.


Is there any way i could get that info.

thanks
Shankar

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com