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

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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Shouldn't pg_settings.enumvals be array of text?
Next
From: Simon Riggs
Date:
Subject: Re: Reducing some DDL Locks to ShareLock