Re: Out of memory

Stephan Szabo <sszabo@megazone23.bigpanda.com>

From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Ivan Boscaino <iboscaino@mbigroup.it>
Cc: <pgsql-bugs@postgresql.org>
Date: 2003-07-10T04:45:57Z
Lists: 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)