Skip site navigation (1) Skip section navigation (2)

WITH RECUSIVE patches 0717

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org, y-asaba(at)sraoss(dot)co(dot)jp
Subject: WITH RECUSIVE patches 0717
Date: 2008-07-17 09:40:25
Message-ID: 20080717.184025.85407905.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi,

Here is the lastest WITH RECURSIVE patches against CVS HEAD created by
Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. (David Fetter's
psql help patches are not included. It seems his git repository has
gone).

This version implements:

- detect certain queries those are not valid acroding to the standard

I also include erroneous query examples created by Yoshiyuki (probably
will become part of regression tests).

Remaining problmes are:

1) sort query names acording to the dependency
2) planner always estimate 0 cost for recursion plans
3) add regression tests

For 1), I have proposed we limit query names to 1, in another word do
not allow mutually recursive queries. For 2) there's no good idea to
solve it, so I suggest leave it as it is now.

For 3) I will generate regression tests as soon as possible.

So the patches seem to be almost ready to commit IMO.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

Attachment: recursive_query.patch.gz
Description: application/octet-stream (19.8 KB)

Responses

pgsql-hackers by date

Next:From: Michael PaesoldDate: 2008-07-17 10:45:42
Subject: Re: PATCH: CITEXT 2.0 v4
Previous:From: Xiao MengDate: 2008-07-17 09:26:38
Subject: [PATCH]-hash index improving

pgsql-patches by date

Next:From: David FetterDate: 2008-07-17 16:01:15
Subject: Re: [PATCHES] WITH RECUSIVE patches 0717
Previous:From: Tatsuo IshiiDate: 2008-07-17 08:56:50
Subject: Re: [PATCHES] WITH RECURSIVE updated to CVS TIP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group