Re: Better error message for a small problem with WITH RECURSIVE

Tom Lane wrote:
> 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.

Yes, please. At least DB2 allows recursive queries without the 
"RECURSIVE" keyword, just "WITH" is enough. Without a hint, anyone 
migrating from such a system will spend hours looking at the query, 
seeing nothing wrong.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com