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
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.
SRA OSS, Inc. Japan
pgsql-hackers by date
|Next:||From: Michael Paesold||Date: 2008-07-17 10:45:42|
|Subject: Re: PATCH: CITEXT 2.0 v4|
|Previous:||From: Xiao Meng||Date: 2008-07-17 09:26:38|
|Subject: [PATCH]-hash index improving|
pgsql-patches by date
|Next:||From: David Fetter||Date: 2008-07-17 16:01:15|
|Subject: Re: [PATCHES] WITH RECUSIVE patches 0717|
|Previous:||From: Tatsuo Ishii||Date: 2008-07-17 08:56:50|
|Subject: Re: [PATCHES] WITH RECURSIVE updated to CVS TIP|