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.
Butit 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