Re: Addendum on stored procedure array limits - Mailing list pgsql-admin

From Paul B. Anderson
Subject Re: Addendum on stored procedure array limits
Date
Msg-id 451C7203.7000604@pnlassociates.com
Whole thread Raw
In response to Re: Addendum on stored procedure array limits  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Addendum on stored procedure array limits  ("Jim C. Nasby" <jim@nasby.net>)
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Addendum on stored procedure array limits
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Addendum on stored procedure array limits