server crash on recursive function invocation
От | Ali Baba |
---|---|
Тема | server crash on recursive function invocation |
Дата | |
Msg-id | 20060531163632.886.qmail@web55502.mail.re4.yahoo.com обсуждение исходный текст |
Ответы |
Re: server crash on recursive function invocation
Re: server crash on recursive function invocation |
Список | pgsql-hackers |
<br />hi,<br />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. <br />fallowing is what i have tried.<br /><br />select max_val from pg_settings wherename='max_stack_depth'; -- returns 2097151<br />set max_stack_depth=2097151;<br />CREATE OR REPLACE FUNCTION func()RETURNS INT AS $$<br />DECLARE<br />x int;<br />BEGIN<br /> null;<br /> x := func();<br /> return 0;<br />END;<br/>$$ LANGUAGE PLPGSQL;<br />select func();<br /> and the server get crashed.<br /><br /><pre><font><font face="Arial,Helvetica, sans-serif">Any ideas?<br /><br />Thanks,<br />--Usman<br /></font></font></pre><br /><br /><br /><br/><br /><p><hr size="1" />Be a chatter box. Enjoy <a href="http://us.rd.yahoo.com/mail_us/taglines/postman12/*http://us.rd.yahoo.com/evt=39663/*http://messenger.yahoo.com">free PC-to-PCcalls </a> with Yahoo! Messenger with Voice.
В списке pgsql-hackers по дате отправления: