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

[<noreply(at)pgfoundry(dot)org>]

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: Closed
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

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

>Comment By: Dave Page  (dpage)
Date: 2006-04-28 08:23

Message:
PRevious codebase - closing.

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

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