Re: Upgrade to 9.1 causing function problem

From: Igor Polishchuk <igor(at)powerreviews(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, Willem Buitendyk <willem(at)pcfish(dot)ca>
Cc: "List: postgresql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrade to 9.1 causing function problem
Date: 2012-02-23 21:15:22
Message-ID: CB6BEC6A.1A27C%igor@powerreviews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Actually, what works is
set search_path='crabdata', 'public' ;

On 2/23/12 1:10 PM, "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com> wrote:

> On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
>> I have it set in postgresql.conf and I've also used:

>> alter user postgres set search_path = crabdata,public;
>>
>
> Well search_path is a string, so have you tried?;
> search_path='crabdata,public'
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-23 21:23:31 Re: Upgrade to 9.1 causing function problem
Previous Message Adrian Klaver 2012-02-23 21:10:50 Re: Upgrade to 9.1 causing function problem