Skip site navigation (1) Skip section navigation (2)

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors
Date: 2006-04-28 08:23:10
Message-ID: 20060428082310.92FC486C509@pgfoundry.org (view raw or flat)
Thread:
Lists: 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 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

pgsql-odbc by date

Next:From: noreplyDate: 2006-04-28 08:24:39
Subject: [ psqlodbc-Bugs-1000600 ] odbc via the local net (lan & Wan)
Previous:From: noreplyDate: 2006-04-28 08:22:35
Subject: [ psqlodbc-Bugs-1000604 ] 8.01.0200 slow with long queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group