Re: Bug with version 08.01.0100 ?

From: "Leendert Paul Diterwich" <paulditerwich(at)gmail(dot)com>
To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Bug with version 08.01.0100 ?
Date: 2005-11-07 11:55:31
Message-ID: 436f40b9.0c6fd48b.5ed7.093f@mx.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear All,

Today again I got an empty odbc error message in my debugger after
installing the 08.01.01 version. Again I'm having great difficulties
replicating this. I there a way I can put the ODBC driver in a kind of debug
mode, that it writes a log what it is doing etc?

Regards,

Paul

-----Oorspronkelijk bericht-----
Van: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] Namens Dave Page
Verzonden: maandag 7 november 2005 12:30
Aan: Dave Page; tc(at)geosys(dot)com; pgsql-odbc(at)postgresql(dot)org
Onderwerp: 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 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Thomas Chabaud 2005-11-07 13:20:01 Re: Bug with version 08.01.0100 ?
Previous Message noreply 2005-11-07 11:33:30 [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors