Re: Addendum on stored procedure array limits

Поиск
Список
Период
Сортировка
От Paul B. Anderson
Тема Re: Addendum on stored procedure array limits
Дата
Msg-id 451C7203.7000604@pnlassociates.com
обсуждение исходный текст
Ответ на Re: Addendum on stored procedure array limits  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Addendum on stored procedure array limits
Список pgsql-admin
There are definitely nulls in there, and in the fields where the error is signaled.  I missed in my reading that they are not allowed.

Thanks.

Paul


Jim C. Nasby wrote:
On Thu, Sep 28, 2006 at 06:13:04PM -0400, Paul B. Anderson wrote: 
I'm running RHEL 3.0 and postgreSQL 8.1.4, compiled from source.   
Have you tried enforcing that there's no NULLs in the arrays? That code
is pretty new (in fact, I thought it was only in 8.2...), so it's
possible that therein lies the bug.

I'd also look into the size of the varchars... if they're big enough you
could be hitting a memory limit somewhere.

In any case, the error message could certainly use improving... :) 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Addendum on stored procedure array limits
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Addendum on stored procedure array limits