[ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors
Date
Msg-id 20060428082310.92FC486C509@pgfoundry.org
Whole thread Raw
List pgsql-odbc
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
crashif 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

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000604 ] 8.01.0200 slow with long queries
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000600 ] odbc via the local net (lan & Wan)