Re: cursors outside transactions

Bruce Momjian wrote:
> 
> Hiroshi Inoue wrote:
> > > I don't see how you can class out of memory in the same likelyhood as
> > > out of disk --- sure they are both real possible failures, but clearly
> > > the latter is more rare and giving folks backing store for large result
> > > sets is a big win in my book.
> >
> > Other than the out of disk/memory problem, there 's
> > another problem. What I expect of cursors is the
> > constant response time while handling them.
> 
> Cursors outside transactions either need materialization or long-lived
> locks 


AccessShare table locks are only needed.
What is wrong with it ?

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/