Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7DE2B9FB2F1 for ; Thu, 28 Sep 2006 22:10:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 44572-10 for ; Fri, 29 Sep 2006 01:10:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 08DE09FA5CE for ; Thu, 28 Sep 2006 22:10:29 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 2AAB156431; Thu, 28 Sep 2006 20:10:28 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 28 Sep 2006 20:10:27 -0500 Date: Thu, 28 Sep 2006 20:10:27 -0500 From: "Jim C. Nasby" To: "Paul B. Anderson" Cc: pgsql-admin@postgresql.org Subject: Re: Addendum on stored procedure array limits Message-ID: <20060929011027.GS34238@nasby.net> References: <451C48F0.30507@pnlassociates.com> <20060929005038.GN34238@nasby.net> <451C7203.7000604@pnlassociates.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <451C7203.7000604@pnlassociates.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060929:paul.a@pnlassociates.com::hr+xmodLU+/4hNUD:0000000000000 0000000000000000000000001Ojn X-Hashcash: 1:20:060929:pgsql-admin@postgresql.org::LaxDFYds1wRcXA6h:00000000000 0000000000000000000000005rMF X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/356 X-Sequence-Number: 23270 You might want to try 8.2 beta then, as support for NULLs in arrays was just added. Testing of that magnitude would be great! On Thu, Sep 28, 2006 at 09:08:19PM -0400, Paul B. Anderson wrote: > 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... :) > > -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)