Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> What we can do is keep a list of "not yet parsed WITH-names" in ParseState, >> and check through that list when about to fail for relation-not-found, and >> issue a suitable message hinting that maybe you forgot RECURSIVE if we find >> a match.
> Perhaps it would be sufficient to just check if we're inside a non-recursive > WITH without bothering to check if the name matches? Even knowing that would require most of the same changes I made to do the full nine yards, I think. The previous ParseState info didn't record anything at all that would allow parserOpenTable to know that a non-recursive WITH is being examined. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers