Re: Addendum on stored procedure array limits - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: Addendum on stored procedure array limits
Date
Msg-id 20060929005038.GN34238@nasby.net
Whole thread Raw
In response to Addendum on stored procedure array limits  ("Paul B. Anderson" <paul.a@pnlassociates.com>)
Responses Re: Addendum on stored procedure array limits  ("Paul B. Anderson" <paul.a@pnlassociates.com>)
List pgsql-admin
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)

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: number of transactions doubling
Next
From: "Paul B. Anderson"
Date:
Subject: Re: Addendum on stored procedure array limits