Re: Addendum on stored procedure array limits

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: "Paul B(dot) Anderson" <paul(dot)a(at)pnlassociates(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Addendum on stored procedure array limits
Date: 2006-09-29 00:50:38
Message-ID: 20060929005038.GN34238@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul B. Anderson 2006-09-29 01:08:19 Re: Addendum on stored procedure array limits
Previous Message Jim C. Nasby 2006-09-29 00:47:36 Re: number of transactions doubling