Re: persistent portals/cursors (between transactions)

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.