"Joel Burton" <jburton@scw.org> writes:
> I think it wasn't just two views pointing at each other (it would, of
> course, be next to impossible to even create those, unless you hand
> tweaked the system tables), but I think was a view-relies-on-a-
> function-relies-on-a-view kind of problem.
Oh, OK. I wouldn't expect the rewriter to realize that that sort of
situation is recursive. Depending on what your function is doing, it
might or might not be an infinite recursion, so I don't think I'd want
the system arbitrarily preventing you from doing this sort of thing.
Perhaps there should be an upper bound on function-call recursion depth
enforced someplace? Not sure.
regards, tom lane