Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Hiroshi Inoue wrote:
>> AccessShare table locks are only needed.
>> What is wrong with it ?
> But that is going to block VACUUM, right?
No. It's a matter of bookkeeping more than anything else. Right now,
transaction end releases all the locks a backend holds. You'd need to
figure out which locks are associated with cross-transaction cursors
and keep those. This overlaps to some extent with bookkeeping that we'd
need to add for nested transactions --- but we haven't got a plan for
that, either.
regards, tom lane