Out of memory

From: Ivan Boscaino <iboscaino(at)mbigroup(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Out of memory
Date: 2003-07-08 09:47:50
Message-ID: 3F0A9346.7020005@mbigroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

In /var/log/messages I found:

[...]
Jul 8 11:21:58 host1 kernel: Out of Memory: Killed process 20586
(postmaster).
[...]

OS: RH7.3 and RH7.2
PG: 7.3.2 and 7.3.3

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dmitry Tkach 2003-07-08 14:15:57 Re: Backwards index scan
Previous Message Tatsuo Ishii 2003-07-08 01:14:23 Re: [HACKERS] again: Bug #943: Server-Encoding from EUC_TW