View Single Post

   
  #3 (permalink)  
Old 04-10-2008, 06:42 AM
Paul B. Anderson
 
Posts: n/a
Default Re: Addendum on stored procedure array limits

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...
>


Reply With Quote