Re: [HACKERS] Should we have an optional limit on the recursion depth of recursive CTEs?

2011-08-15 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: Should we have an optional, disabled-by-default limit on the recursion/iteration depth of recursive CTEs to guard against stupid queries that loop ad infinitum? I think not ... I'd suggest that an appropriate interface would be an int GUC with a

Re: [HACKERS] Should we have an optional limit on the recursion depth of recursive CTEs?

2011-08-15 Thread Peter Geoghegan
On 15 August 2011 21:31, Tom Lane t...@sss.pgh.pa.us wrote: I'd suggest that an appropriate interface would be an int GUC with a GucContext of PGC_SUSET, so that DBAs can impose system-wide limits. ... and that would be a seriously bad API.  There are not SUSET restrictions on other resources