m.c.wilkins@xxxxxxxxxxxx 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
