Re: [HACKERS] server crash on recursive function invocation

2006-05-31 Thread Tom Lane
Ali Baba <[EMAIL PROTECTED]> writes: > 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. There's a reason why that variable is a superuser-only setting: you're supposed to have some clue what you're doing wh

Re: [HACKERS] server crash on recursive function invocation

2006-05-31 Thread Andrew Dunstan
Ali Baba said: > > 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_

[HACKERS] server crash on recursive function invocation

2006-05-31 Thread Ali Baba
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 2097151set max_stack_depth=2097151;CREATE OR REPLACE FU