Hi, From: Zoltan Boszormenyi <[EMAIL PROTECTED]> Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1 Date: Mon, 19 May 2008 08:19:17 +0200
> >> Also, it seems there are no infinite recursion detection: > >> > >> # with recursive x(level, parent, child) as ( > >> select 1::integer, * from test_connect_by where parent is null > >> union all > >> select x.level + 1, base.* from test_connect_by as base, x where > >> base.child > >> = x.child > >> ) select * from x; > >> ... it waits and waits and waits ... > >> > > > > Well, psql might wait and wait but it's actually receiving rows. A cleverer > > client should be able to deal with infinite streams of records. > > > > 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"? Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
