On 02/23/12 11:49 AM, Willem Buitendyk wrote:
2012-02-23 11:31:44 PST WARNING invalid value for parameter "search_path": 
"crabdata"       
2012-02-23 11:31:44 PST DETAIL  schema "crabdata" does not exist      

Bizarre because I did set my search path to the schema crabdata but now it is 
saying that crabdata doesn't exist.  But it clearly does.  I'm at a loss.

add the database name to your log_line_prefix ...  I use something like...

    log_line_prefix = '%m %u@%d[%p]: '

so my log lines look like...


2012-02-21 14:04:21.595 PST user@dbname[8888]: ERROR: .....


(where 8888 is the pid)... I'm suggesting this so you can confirm that you are getting this error on the database you think it is, and not something else.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to