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-24 02:04:55
Message-ID: 201202231804.56078.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-02-24 02:19:32 Re: Optimise PostgreSQL for fast testing
Previous Message Greg Smith 2012-02-24 01:43:46 Re: Optimise PostgreSQL for fast testing