Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group