| From: | "Paul B(dot) Anderson" <paul(dot)a(at)pnlassociates(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Stored procedure array limits |
| Date: | 2006-09-28 22:11:55 |
| Message-ID: | 451C48AB.6090508@pnlassociates.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
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
CONTEXT: PL/pgSQL function "name_search" line 64 at assignment
I have not exceeded the size of the arrays, index-wise.
I increased max_stack_depth to 32768 and work_mem to 32768 but without
effect.
If I comment out two particular arrays (that can have null values), it
also runs OK.
Anybody have any ideas?
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul B. Anderson | 2006-09-28 22:13:04 | Addendum on stored procedure array limits |
| Previous Message | Sriram Dandapani | 2006-09-28 22:07:07 | autovacuum ignore tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Casey Duncan | 2006-09-28 22:19:46 | Expected accuracy of planner statistics |
| Previous Message | Alan Hodgson | 2006-09-28 22:06:49 | Re: Row versions and indexes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gevik Babakhani | 2006-09-28 22:28:55 | Re: Row IS NULL question |
| Previous Message | David Wheeler | 2006-09-28 22:07:39 | Patch: Tie stats options to autovacuum in postgresql.conf |