Re: Stored procedure array limits

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Paul B. Anderson" <paul(dot)a(at)pnlassociates(dot)com> writes:
> I have a large stored procedure with 16 arrays, mostly varchar, each 
> with dimension 3000.  The procedure works fine on a small number of rows 
> used from these arrays but gets the following error for large rowsets:

>   ERROR:  invalid array subscripts

Right offhand I only see that error being thrown for out-of-range array
subscripts.  Are you maybe trying to fill the arrays in nonsequential
order?

> If I comment out two particular arrays (that can have null values), it 
> also runs OK.

As already noted, we don't support nulls in arrays before 8.2, but
I'm not exactly sure how that omission leads to this error message.

			regards, tom lane