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

From Hiroshi Inoue
Subject Re: persistent portals/cursors (between transactions)
Date
Msg-id 3C50C6F2.758FC8FA@tpf.co.jp
Whole thread Raw
In response to Re: persistent portals/cursors (between transactions)  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: persistent portals/cursors (between transactions)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Florian Wunderlich wrote:
>
> 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,

I forgot to mention that I'd like to implement a cross
transaction insensitive(and read-only) cursors which
any proper dbms seems to have the functionality.

regards,
Hiroshi Inoue

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Yet another optimizer index choosing questions
Next
From: Bruce Momjian
Date:
Subject: Re: persistent portals/cursors (between transactions)