Gareth Boden <gareth(dot)boden(at)egsgroup(dot)com> writes:
> Bizarrely, it came down to an infinite recursion in a plpgsql function
> we were using which exhausted memory and crashed the db server. Is
> there any way of limiting stack depth/having some sort of monitor on
> these functions to prevent this behaviour in future?
There's been some talk of this, but the sticking point has been to
figure out a reasonably portable way to measure and enforce stack
usage...
regards, tom lane