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