Re: Out of memory - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Out of memory
Date
Msg-id 20030709214512.N28062-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Out of memory  (Ivan Boscaino <iboscaino@mbigroup.it>)
Responses Re: Out of memory
Re: Out of memory
List pgsql-bugs
On Tue, 8 Jul 2003, Ivan Boscaino wrote:

> Hi,
> I'm not sure if you know this problem.
>
> Create an empty function with 26 parameters:
>
> create function test (INTEGER,TEXT,TEXT,TEXT,CHAR(16),CHAR(11),
> BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,
> BOOLEAN,BOOLEAN,BOOLEAN,CHAR(2),TEXT,TEXT,TEXT,TEXT,
> CHAR(5),TEXT,TEXT,TEXT,TEXT,TEXT )
> returns integer as '
> declare
> begin
>   return 0;
> end;' language 'plpgsql';
>
>
> Call it mistyping the boolean parameters:
>
> select test
> (1,'a','a','a','a','a',1,1,1,1,1,1,1,1,1,'a','a','a','a','a','a','a','a','a','a','a');
>
> Then the system crashes.

I believe this is fixed in 7.4 (or at least your example does not crash in
7.4)

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Precision errors in float8 type casting (as of 7.3.2 and
Next
From: Joe Conway
Date:
Subject: Re: Out of memory