Re: Upgrade to 9.1 causing function problem

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