Re: Submitting cursored query support, docs, etc

Hi!

2007/12/10, Dave Page <dpage(at)postgresql(dot)org>:
> Kalle Hallivuori wrote:
> > Hi again Dave and others,
> >
> > 2007/11/29, Dave Page <dpage(at)postgresql(dot)org>:
> >> I'd be very happy to look at your code. Obviously I cannot guarantee
> >> that it would all be incorporated into the base product, but certainly
> >> all of the items above sound very interesting (I've personally wanted to
> >> add a cursor mode to the query tool for some time).
> >
> > I'm trying to figure out where to add this. Insights are welcome.
>
> Sorry, I'm not sure I understand - if you're talking about the patch,
> please just mail it to the list.

Actually, I'm still wondering how to do this. We need to

1. submit the SELECT to server so that it produces a CURSOR instead of
a result set,
2. fetch and view rows from CURSOR instead of a ready-made result set,
3. handle a new state where a query is running but passive in a way
which enables more interaction than just stopping the current query.
Maybe we can call this state "active".

I'm reading the code but I'm still not crystal clear on where and how
to make those changes. That is where I'm welcoming input. Maybe there
are some classes, methods or properties that you could point me to? If
you've considered it yourself, which parts of code have you thought
you would change, and how?

--
Kalle Hallivuori +358-41-5053073 http://korpiq.iki.fi/