Re: Postgres and recursion

glenn <vmstech(at)tpg(dot)com(dot)au> writes:
> I've got this simple function which climbs up a 'selfjoin' tree called
> job, and reports back the id of the root of the tree. It seemed to work
> in 7.2 (which I'm told doesn't recurse???), but I've just upgraded to
> 7.3.2 (i.e debians latest) and when I execute it, the server kicks me
> off, like so:

That sounds like a bug, but you have not provided enough detail to let
anyone try to reproduce it --- the function uses a table that you
haven't described, and any specific call would depend on the contents
of the table, which you haven't given.

The function does appear to be capable of going into infinite recursion
if the table contents are wrong (eg two nodes pointing at each other),
but AFAICS that would lead to stack-overflow coredump in any PG version.

regards, tom lane