Re: [PATCHES] WITH RECURSIVE patch V0.1 - Mailing list pgsql-hackers

From Yoshiyuki Asaba
Subject Re: [PATCHES] WITH RECURSIVE patch V0.1
Date
Msg-id 20080521.233422.1000278277145531989.y-asaba@sraoss.co.jp
Whole thread Raw
In response to Re: [PATCHES] WITH RECURSIVE patch V0.1  (David Fetter <david@fetter.org>)
Responses Re: [PATCHES] WITH RECURSIVE patch V0.1  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Hi,

From: David Fetter <david@fetter.org>
Subject: Re: [HACKERS] [PATCHES] WITH RECURSIVE patch V0.1
Date: Mon, 19 May 2008 04:36:30 -0700

> > > I think it's the other way around. The server should not emit
> > > infinite number of records.
> >
> > How about adding new GUC parameter "max_recursive_call"?
>
> 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.

Regards,
--
Yoshiyuki Asaba
y-asaba@sraoss.co.jp

pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: idea: storing view source in system catalogs
Next
From: "Pavel Stehule"
Date:
Subject: plpgpsm future