Re: persistent portals/cursors (between transactions)

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Florian Wunderlich <fwunderlich(at)devbrain(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: persistent portals/cursors (between transactions)
Date: 2002-01-25 02:46:10
Message-ID: 3C50C6F2.758FC8FA@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-01-25 03:19:52 Re: persistent portals/cursors (between transactions)
Previous Message Stephan Szabo 2002-01-25 01:05:38 Re: Yet another optimizer index choosing questions