Search Postgresql Archives

Re: Upgrade to 9.1 causing function problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Both via psql and PgAdmin.  

Yes only one database cluster.


On 2012-02-23, at 1:32 PM, Adrian Klaver 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;
>> 
>> looking at the logs after issuing the above alter user command I get:
>> 
>> 2012-02-23 13:03:09 PST	WARNING	invalid value for parameter "search_path": "crabdata, public"	
>> 2012-02-23 13:03:09 PST	DETAIL	schema "crabdata" does not exist	
> 
>> 
>> I should note this is on Windows 7 64 bit - using the 32 bit installation of postgresql 9.1
> 
> How are you doing these changes, via psql or PgAdmin or both?
> Is the previous 8.4 instance of Postgres still up and running?
> Are you sure you are only working with one database cluster?
> 
>> 
>> 
>> 
> 
> 
> -- 
> Adrian Klaver
> adrian.klaver@xxxxxxxxx


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux