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,
>
> 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.

That is a good idea, especially read-only, that will not require any
locks.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026