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 |
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 |
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 |