m.c.wilkins@massey.ac.nz writes:
> i would like to allow updates to a view, but pgsql crashes,
> presummably from an infinite loop.
If it crashes, that's a bug, regardless of whether the code is doing
what you want. However, if the thing is indeed into an infinite
recursion, you might be running out of stack space, in which case the
bug is an incorrect setting of max_stack_depth. (PG 8.2 should be able
to set max_stack_depth for itself on most platforms, but older releases
rely on you to get it right.) If you reduce max_stack_depth, do you get
an error message instead of a crash? What are the exact crash symptoms,
anyway? And which PG version is this?
regards, tom lane