| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Paul B(dot) Anderson" <paul(dot)a(at)pnlassociates(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Stored procedure array limits |
| Date: | 2006-09-29 03:57:12 |
| Message-ID: | 9461.1159502232@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2006-09-29 04:22:21 | Re: autovacuum ignore tables |
| Previous Message | Chan Michael | 2006-09-29 02:24:01 | 回覆： Re: How can I restore from WAL log? [PG 7.3] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Damian C | 2006-09-29 05:29:18 | Do non-sequential primary keys slow performance significantly?? |
| Previous Message | Tom Lane | 2006-09-29 03:51:01 | Re: Expected accuracy of planner statistics |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-29 04:07:58 | Re: New version of money type |
| Previous Message | Jim C. Nasby | 2006-09-29 03:53:29 | Re: New version of money type |