<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.