[ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors

Bugs item #1000413, was opened at 2005-11-07 11:33
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000413&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Dave Page (dpage)
Assigned to: Nobody (None)
Summary: Optimistic lock cannot be used with updateable cursors

Initial Comment:
When using VB/ADO, adLockOptimistic or adLockBatchOptimistic when used with adOpenStatic or adOpenKeyset will cause a crash if UpdateableCursors are enabled.

Sample VB code:

Dim cn As New Connection
Dim rs As New Recordset

cn.Open "DSN=foo;UID=postgres;UpdatableCursors=1"
rsSQL.Open "SELECT * FROM pg_class", cn, adOpenStatic, adLockOptimistic

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000413&group_id=1000125