Re: Better error message for a small problem with WITH RECURSIVE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Better error message for a small problem with WITH RECURSIVE
Date
Msg-id 27556.1223469961@sss.pgh.pa.us
Whole thread Raw
In response to Re: Better error message for a small problem with WITH RECURSIVE  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: About postgresql8.3.3 build in MS VS2005
Next
From: Emmanuel Cecchet
Date:
Subject: Re: Transactions and temp tables