Re: Upgrade to 9.1 causing function problem

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Upgrade to 9.1 causing function problem
Дата
Msg-id 201202231804.56078.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на Re: Upgrade to 9.1 causing function problem  (Willem Buitendyk <willem@pcfish.ca>)
Ответы Re: Upgrade to 9.1 causing function problem
Re: Upgrade to 9.1 causing function problem
Re: Upgrade to 9.1 causing function problem
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Optimise PostgreSQL for fast testing
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Optimise PostgreSQL for fast testing