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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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 Content-Type Size
recursive_query.patch.gz application/octet-stream 19.8 KB

Responses

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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