Re: [PROPOSAL] Max recursion depth in WITH Queries (Common Table Expressions)

2015-10-28 8:33 GMT+01:00 Valery Popov <v(dot)popov(at)postgrespro(dot)ru>:

> Hi, Hackers
>
> Recursive queries are typically used to deal with hierarchical or
> tree-structured data.
> In some conditions when data contain relationships with cycles recursive
> query will loop
> unlimited and significantly slows the client's session.
> To prevent "infinite" loop I suggest the max_recursion_depth parameter,
> which defines the maximum recursion level during the execution of recursive
> query.
> When max_recursion_depth > 0 and the recursion level of query exceeds
> specified value then the execution of query interrupts with error message.
> In the MS SQL Server there is MAXRECURSION hint for the same purpose.
>
>
+1

good idea

Regards

Pavel

>
> Thanks!
> --
>
> Regards,
> Valery Popov
> Postgres Professional http://www.postgrespro.com
> The Russian Postgres Company
>
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>