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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026