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

Re: Bug with version 08.01.0100 ?

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, <tc(at)geosys(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Bug with version 08.01.0100 ?
Date: 2005-11-07 11:29:40
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC398D@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: 07 November 2005 11:13
> To: tc(at)geosys(dot)com; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Bug with version 08.01.0100 ?
> 
>  
> 
> > -----Original Message-----
> > From: pgsql-odbc-owner(at)postgresql(dot)org 
> > [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> > Sent: 07 November 2005 10:55
> > To: tc(at)geosys(dot)com; pgsql-odbc(at)postgresql(dot)org
> > Subject: Re: [ODBC] Bug with version 08.01.0100 ?
> > 
> >  
> > I've tried your connection string (modified for my local server of
> > course) and rs.Open (but with pg_class), and it does seem that only
> > adOpenForwardOnly and adOpenDynamic work as expected :-(. 
> I'll open a
> > tracker about this.
> 
> Sorry - that's not quite right - it seems that adLockOptimistic or
> adLockBatchOptimistic are the culprits. They will only work with
> adOpenForwardOnly. adLockPessimistic or adLockReadOnly seem to work OK
> with any cursor type.

PPS: This only appears to happen with UpdateableCursors enabled, which
is an experimental feature anyway.

Regards, Dave.

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2005-11-07 11:33:30
Subject: [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors
Previous:From: Dave PageDate: 2005-11-07 11:13:16
Subject: Re: Bug with version 08.01.0100 ?

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