Re: persistent portals/cursors (between transactions) - Mailing list pgsql-general

From Florian Wunderlich
Subject Re: persistent portals/cursors (between transactions)
Date
Msg-id 3C5043D0.D8201E9B@hq.factor3.com
Whole thread Raw
In response to Re: persistent portals/cursors (between transactions)  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-general
Hiroshi Inoue wrote:
>
> > -----Original Message-----
> > From: Tom Lane
> >
> > > I'd really like to have persistent insensitive cursors,
> >
> > Seems a lot easier to just select the data you want into a temp table.
>
> 1) It may need large space.
> 2) It may take long time to respond.

Which are exactly the problems in my case.

> If no one would try this importgant TODO I would try it
> in the next year release.

I absolutely want to have this feature because it makes my life a lot
easier, so I'll contribute as much time as possible, though I can't do
it right now as we're done evaluating databases, stuck with Postgresql,
and are bound to implement a workaround on client side first, as that's
crappy and anything but nice, but it'll get the product out on time.

When I start hacking it I'll give you notice in case you already started
on it.

BTW, if anyone wants to put up short comparison of Interbase, SAPDB and
PostgreSQL feature and restriction wise, drop me a line.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with initdb on Cygwin
Next
From: Jan Wieck
Date:
Subject: Re: Problems with initdb on Cygwin