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. > > I would think this is overkill, except I've made the same darn mistake > one time too many. It seems clear to me that a lot of other people will > make it too, and if the error message isn't more helpful a lot of time > will get wasted. Barring loud objections, I'm gonna go change it.
Perhaps it would be sufficient to just check if we're inside a non-recursive WITH without bothering to check if the name matches? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
