Re: recursive SQL

seems evgen has got a sql99 compliant version of recursive SQL out and would agree to relicense it.
are there any other concerns regarding evgens work? or do you want to encourage him to go this route? i have the impression he would happily join in on the postgres developement wrt recursive SQL, and some friendly words might encourage him to do the required work.

cheers,
jacob

> -----Original Message-----
> From: Potemkin Evgen [mailto:gppl(at)inbox(dot)ru]
> Sent: 28 June 2004 16:05
> To: jacob koehler (RRes-Roth)
> Subject: Re: FW: [HACKERS] recursive SQL
>
>
> Hello,
>
> yes, it would be great if patch will be included in postgres,
> and if it needed sure i will relicense it to BSD. problem is
> that core team don't want to include it at all. (see message
> from Tom Lane on this topic). some peoples already tried to
> get the patch in pg's distro, but without any result.
>
> the funny thing that i almost get working implementation
> of SQL99 recursive queries,"just for fun";), and i think
> it would not be included too;)
>
> regards,
> evgen
> -----Original Message-----
>
> >dear evgen potemkin,
> >
> >i hope you dont mind that i have taken this step. i saw that you
> >invested some serious work, and your webpage gave me the impression
> >that you are happy to share your patch.
> >
> >However, it seems that if you would want to make your code
> part of the
> >official postgres release, it also seems you would have to
> license your
> >patch under the same license as postgres itself, which is
> not GPL, but
> >BSD, see: http://www.postgresql.org/licence.html
> >
> >i think it would be very useful to have your patch as part of the
> >official release...
> >
> >regards,
> >jacob
> >
> >
> >> -----Original Message-----
> >> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> >> Sent: 26 June 2004 20:42
> >> To: pgsql-hackers(at)postgresql(dot)org
> >> Subject: Re: [HACKERS] recursive SQL
> >>
> >> jacob koehler (RRes-Roth) wrote:
> >>
> >> >hi,
> >> >
> >> >i am wondering what you think about including evgen
> potemkin's patch
> >> >for recursive SQL in the next postgres version:
> >> >http://gppl.terminal.ru/
> >> >
> >> >[snip]
> >> >
> >>
> >> >- Evgen DID publish this patch under GPL, see:
> >> >http://gppl.terminal.ru/README.html
> >> >
> >>
> >> It would first have to be relicensed ...
> >>
> >> cheers
> >>
> >> andrew
> >>
>
>

Hi Evgen,

I'm a PostgreSQL developer and I would like to see an SQL99 recursive
queries feature in PostgreSQL.

I'm pretty sure that Tom would be happy with an SQL99 compliant version
of your patch, so long as it's up to scratch with the normal PostgreSQL
coding and reliability standards.

I'm not a committer myself, so I think I should explain how things work.
We're unlike other projects that seem to accept almost anything that
comes our way. In many ways, it's the patches that the committers
reject that make PostgreSQL strong.

To get your patch accepted, you have to be prepared to work WITH the
committers, especially Tom, and make changes based on their feedback. I
know this costs you in wounded pride (I get the same feeling sometimes),
but in the end it's worth it. Sometimes the committers are very busy
and it takes ages before someone actually reviews your patch. Don't
take that as a snub, take it as an opportunity to keep working on it!

I think that you and the PostgreSQL project can meet somewhere in the
middle on this and we can get your stuff in for the 7.6 release (it's
too late for 7.5 right now). Don't take this as a guarantee of course,
but if you'll willing to work with us and stick with the patch, then I
think it will get in.

Comments?

Regards,

Chris
--
PostgreSQL Developer

jacob koehler (RRes-Roth) wrote:
> seems evgen has got a sql99 compliant version of recursive SQL out and would agree to relicense it.
> are there any other concerns regarding evgens work? or do you want to encourage him to go this route? i have the impression he would happily join in on the postgres developement wrt recursive SQL, and some friendly words might encourage him to do the required work.
>
> cheers,
> jacob
>
>
>>-----Original Message-----
>>From: Potemkin Evgen [mailto:gppl(at)inbox(dot)ru]
>>Sent: 28 June 2004 16:05
>>To: jacob koehler (RRes-Roth)
>>Subject: Re: FW: [HACKERS] recursive SQL
>>
>>
>>Hello,
>>
>>yes, it would be great if patch will be included in postgres,
>>and if it needed sure i will relicense it to BSD. problem is
>>that core team don't want to include it at all. (see message
>>from Tom Lane on this topic). some peoples already tried to
>>get the patch in pg's distro, but without any result.
>>
>>the funny thing that i almost get working implementation
>>of SQL99 recursive queries,"just for fun";), and i think
>>it would not be included too;)
>>
>>regards,
>>evgen

On T, 2004-06-29 at 13:11, jacob koehler (RRes-Roth) wrote:
> seems evgen has got a sql99 compliant version of recursive SQL
> out and would agree to relicense it.
> are there any other concerns regarding evgens work? or do you want to
> encourage him to go this route? i have the impression he would happily
> join in on the postgres developement wrt recursive SQL, and some friendly
> words might encourage him to do the required work.

> > the funny thing that i almost get working implementation
> > of SQL99 recursive queries,"just for fun";), and i think
> > it would not be included too;)

Maybe he knows of some fundamental flaws with his implementation ?

Why else does he think that it will not be accepted ?

He could at least try to submit it again, once it is past the "almost"
part :)

BTW, I also "almost" got a working implementation of SQL99 recursive
queries (at least it parsed the syntax ;), but gave up due to lack of
time and also because the SQL99 recursive queries are a desceptively
complex beast which I was unable to fully understand from the specs, at
least the part beyond the simple parent-child tree queries.

And the simple parent-child tree queriest are now doable using
set-returning functions.

----------------
Hannu

On Tue, Jun 29, 2004 at 07:23:45PM +0800, Christopher Kings-Lynne wrote:
> I'm a PostgreSQL developer and I would like to see an SQL99 recursive
> queries feature in PostgreSQL.

Me too, on bot parts.

> I'm not a committer myself, so I think I should explain how things work.
> We're unlike other projects that seem to accept almost anything that
> comes our way. In many ways, it's the patches that the committers
> reject that make PostgreSQL strong.

Actaully I am a committer and I would stil not touch that part of the
source as I never worked on it. I just commit patches that I can
personally judge to be good.

But nevertheless I would be very interested in helping with this patch
as recursive query optimization was one are I wokred on for my ph.d.

Granted spare time is a problem, but we should be able to finish this
for 7.6.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

ok, i'll fix some nasty bugs, and post it here for review.

regards,
evgen
-----Original Message-----

>
>On Tue, Jun 29, 2004 at 07:23:45PM +0800, Christopher Kings-Lynne wrote:
>> I'm a PostgreSQL developer and I would like to see an SQL99 recursive
>> queries feature in PostgreSQL.
>
>Me too, on bot parts.
>
>> I'm not a committer myself, so I think I should explain how things work.
>> We're unlike other projects that seem to accept almost anything that
>> comes our way. In many ways, it's the patches that the committers
>> reject that make PostgreSQL strong.
>
>Actaully I am a committer and I would stil not touch that part of the
>source as I never worked on it. I just commit patches that I can
>personally judge to be good.
>
>But nevertheless I would be very interested in helping with this patch
>as recursive query optimization was one are I wokred on for my ph.d.
>
>Granted spare time is a problem, but we should be able to finish this
>for 7.6.
>
>Michael
>--
>Michael Meskes
>Email: Michael at Fam-Meskes dot De
>ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
>Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
>