Re: Upgrade to 9.1 causing function problem - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Upgrade to 9.1 causing function problem
Date
Msg-id 201202231804.56078.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: Upgrade to 9.1 causing function problem  (Willem Buitendyk <willem@pcfish.ca>)
Responses Re: Upgrade to 9.1 causing function problem
Re: Upgrade to 9.1 causing function problem
Re: Upgrade to 9.1 causing function problem
List pgsql-general
On Thursday, February 23, 2012 1:53:42 pm Willem Buitendyk wrote:
> Both via psql and PgAdmin.
>
> Yes only one database cluster.
>

Another thought.
Did you CREATE the schema using PgAdmin and if so,  might you have inadvertently
put in a trailing or leading space ?
I ask because if I remember correctly PgAdmin by default quotes object names and
that would trap the space character.

I know  you showed this previously:

"crabby";"crabdata";"postgres";"";"";"";""

On the chance that spaces where trimmed out of the above what does the query
below show?:

SELECT length(schema_name), schema_name from information_schema.schemata;

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Optimise PostgreSQL for fast testing
Next
From: Scott Marlowe
Date:
Subject: Re: Optimise PostgreSQL for fast testing