Re: [GENERAL] Warning: Don't delete those /tmp/.PGSQL.* files - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Warning: Don't delete those /tmp/.PGSQL.* files
Date
Msg-id 18615.975543917@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Warning: Don't delete those /tmp/.PGSQL.* files  ("Joel Burton" <jburton@scw.org>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Joel Burton"
Date:
Subject: Rules with Conditions: Bug, or Misunderstanding
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Rules with Conditions: Bug, or Misunderstanding