Home > Archive > PostgeSQL ODBC > November 2005 > [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors
noreply@pgfoundry.org

2005-11-14, 8:23 pm

Bugs item #1000413, was opened at 2005-11-07 11:33
You can respond by visiting:
http://pgfoundry.org/tracker/?func=...roup_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 adLockBatchOptimisti
c 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=...roup_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com