Re: [HACKERS] WITH RECURSIVE patch V0.1 - Mailing list pgsql-patches

From Joshua D. Drake
Subject Re: [HACKERS] WITH RECURSIVE patch V0.1
Date
Msg-id 1211388530.25082.21.camel@jd-laptop
Whole thread Raw
In response to Re: [HACKERS] WITH RECURSIVE patch V0.1  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: [HACKERS] WITH RECURSIVE patch V0.1  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
> >> Couldn't we just have it pay attention to the existing
> >> max_stack_depth?
> >
> > Recursive query does not consume stack. The server enters an infinite
> > loop without consuming stack. Stack-depth error does not happen.
>
> We could have a separate guc variable which limits the maximum number of
> levels of recursive iterations. That might be a useful feature for DBAs that
> want to limit their users from issuing an infinite query.
>

statement_timeout :)

Joshua D. Drake




pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: [HACKERS] WITH RECURSIVE patch V0.1
Next
From: Gregory Stark
Date:
Subject: Re: [HACKERS] WITH RECURSIVE patch V0.1