Re: Upgrade to 9.1 causing function problem

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Willem Buitendyk <willem(at)pcfish(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade to 9.1 causing function problem
Date: 2012-02-23 22:56:37
Message-ID: 4F46C425.4020801@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/23/2012 01:53 PM, Willem Buitendyk wrote:
> Both via psql and PgAdmin.
>
> Yes only one database cluster.

1)
Did you try Johns recommendation, just to be sure?:
"
add the database name to your log_line_prefix ... I use something like...

log_line_prefix = '%m %u(at)%d[%p]: '
"

2)
So what happens if you change your function to have an explicit schema
reference to the table?:

update crabdata.activity_month set action_month = $1;

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-02-23 22:58:01 Re: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
Previous Message Willem Buitendyk 2012-02-23 21:53:42 Re: Upgrade to 9.1 causing function problem