Hm, in psql if I set FETCH_COUNT to a nonzero value I suddenly find I'm unable to use SELECT ... FOR UPDATE.
I suspect this is unnecessary, that the only reason cursors can't hold locks is because we don't support the kind of read-write operations that clients may expect to be able to issue against read-write cursors? But if we're using cursors to work around the libpq interface limitations then perhaps this restriction shouldn't apply? postgres=# select * from test for update; ERROR: DECLARE CURSOR ... FOR UPDATE/SHARE is not supported DETAIL: Cursors must be READ ONLY. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster