hi,
i was just trying recursive function invocation and got a server crash when i changed a GUC variable max_stack_depth, to a high number.
fallowing is what i have tried.
select max_val from pg_settings where name='max_stack_depth'; -- returns 2097151
set max_stack_depth=2097151;
CREATE OR REPLACE FUNCTION func() RETURNS INT AS $$
DECLARE
x int;
BEGIN
null;
x := func();
return 0;
END;
$$ LANGUAGE PLPGSQL;
select func();
and the server get crashed.
Any ideas?
Thanks,
--Usman
---------------------------------
Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice.