Re: Addendum on stored procedure array limits

From: "Paul B(dot) Anderson" <paul(dot)a(at)pnlassociates(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Addendum on stored procedure array limits
Date: 2006-09-29 01:08:19
Message-ID: 451C7203.7000604@pnlassociates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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... :)
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-09-29 01:10:27 Re: Addendum on stored procedure array limits
Previous Message Jim C. Nasby 2006-09-29 00:50:38 Re: Addendum on stored procedure array limits