Out of memory
Ivan Boscaino <iboscaino@mbigroup.it>
From: Ivan Boscaino <iboscaino@mbigroup.it>
To: pgsql-bugs@postgresql.org
Date: 2003-07-08T09:47:50Z
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