| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Upgrade to 9.1 causing function problem |
| Date: | 2012-02-23 21:08:18 |
| Message-ID: | 4F46AAC2.9030305@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)%d[%p]: '
so my log lines look like...
2012-02-21 14:04:21.595 PST user(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayashankar K B | 2012-02-23 21:09:10 | Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 |
| Previous Message | Willem Buitendyk | 2012-02-23 21:08:12 | Re: Upgrade to 9.1 causing function problem |