pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Addendum on stored procedure array limits
4+ messages / 2 participants
[nested] [flat]

* Addendum on stored procedure array limits
@ 2006-09-28 22:13  Paul B. Anderson <paul.a@pnlassociates.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Paul B. Anderson @ 2006-09-28 22:13 UTC (permalink / raw)
  To: pgsql-admin

I'm running RHEL 3.0 and postgreSQL 8.1.4, compiled from source.

Paul




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Addendum on stored procedure array limits
@ 2006-09-29 00:50  Jim C. Nasby <jim@nasby.net>
  parent: Paul B. Anderson <paul.a@pnlassociates.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jim C. Nasby @ 2006-09-29 00:50 UTC (permalink / raw)
  To: Paul B. Anderson <paul.a@pnlassociates.com>; +Cc: 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)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Addendum on stored procedure array limits
@ 2006-09-29 01:08  Paul B. Anderson <paul.a@pnlassociates.com>
  parent: Jim C. Nasby <jim@nasby.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Paul B. Anderson @ 2006-09-29 01:08 UTC (permalink / raw)
  To: 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... :)
>   

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Addendum on stored procedure array limits
@ 2006-09-29 01:10  Jim C. Nasby <jim@nasby.net>
  parent: Paul B. Anderson <paul.a@pnlassociates.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Jim C. Nasby @ 2006-09-29 01:10 UTC (permalink / raw)
  To: Paul B. Anderson <paul.a@pnlassociates.com>; +Cc: pgsql-admin

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)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-09-29 01:10 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-28 22:13 Addendum on stored procedure array limits Paul B. Anderson <paul.a@pnlassociates.com>
2006-09-29 00:50 ` Jim C. Nasby <jim@nasby.net>
2006-09-29 01:08   ` Paul B. Anderson <paul.a@pnlassociates.com>
2006-09-29 01:10     ` Jim C. Nasby <jim@nasby.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox