[ 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 20051107113330.7D6B71125019@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: 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
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

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

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

pgsql-odbc by date:

Previous
From: Claus Scherschel
Date:
Subject: Selecting schemas in ODBC/Win32
Next
From: Peter Eisentraut
Date:
Subject: Re: Recommended ODBC version for compilation