server crash on recursive function invocation

From: Ali Baba <idofyear(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: server crash on recursive function invocation
Date: 2006-05-31 16:36:32
Message-ID: 20060531163632.886.qmail@web55502.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2006-05-31 16:43:23 Re: copy progress notification
Previous Message Andreas Pflug 2006-05-31 16:35:00 Re: Possible TODO item: copy to/from pipe