The following bug has been logged online:
Bug reference: 5131
Logged by: aihongwei
Email address: ufo008ahw(at)163(dot)com
PostgreSQL version: 8.0.0
Operating system: linux x86_64
Description: The pgsql will lost
Details:
In x86_64 platform,
I input command "ulimit -s 2048" to limit the stack size.Then I startup the
server,and when i do some recursion operation, the pgsql will lost in some
time.
It seems that The stack_max_depth does work.
example:
CREATE FUNCTION infinite_recurse() returns int as
'select infinite_recurse()' language sql;
select infinite_recurse();