Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5F5D59FB32F for ; Thu, 28 Sep 2006 19:12:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68763-07 for ; Thu, 28 Sep 2006 19:12:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail734.megamailservers.com (mail734.megamailservers.com [69.49.98.44]) by postgresql.org (Postfix) with ESMTP id 9737F9FB332 for ; Thu, 28 Sep 2006 19:12:01 -0300 (ADT) X-Authenticated-User: paul.a.pnlassociates.com Received: from [69.3.2.106] (h-69-3-2-106.mclnva23.covad.net [69.3.2.106]) (authenticated bits=0) by mail734.megamailservers.com (8.13.6.20060614/8.13.1) with ESMTP id k8SMBupB029219 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 28 Sep 2006 18:11:59 -0400 Message-ID: <451C48AB.6090508@pnlassociates.com> Date: Thu, 28 Sep 2006 18:11:55 -0400 From: "Paul B. Anderson" User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Stored procedure array limits Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.197 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/346 X-Sequence-Number: 23260 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