Re: SELECT ... FOR UPDATE and ResultSet

Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
> Can I count on this behavior for PostgreSQL?  Or will it fail to lock
> all rows if
> I have a sufficiently large ResultSet and Connection.setFetchSize() does
> it's magic?

In the current implementation, the backend will only lock those rows
actually returned to the client.  If setFetchSize() causes not all the
rows to be fetched, you lose ...

            regards, tom lane