Re: JDBC3 + HOLD_CURSORS_OVER_COMMIT

Oliver Jowett wrote:
> It occurred to me that we can support JDBC3's
> HOLD_CURSORS_OVER_COMMIT behaviour quite simply by doing the same
> thing we do with scrollable resultsets -- disable use of cursors
> entirely.
>
> Does this sound worth doing? Obviously we could replace it with
> proper WITH HOLD cursor-backed resultsets eventually..

PostgreSQL 7.4 supports holdable cursors.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/