From: | Thomas Chabaud <tc(at)geosys(dot)com> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Bug with version 08.01.0100 ? |
Date: | 2005-11-07 13:20:01 |
Message-ID: | 436F5481.6010204@geosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dave Page a écrit :
>
>
>
>>-----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
>
>
Thanks a lot for your quick answer.
It works well with UpdateableCursors=0;
Regards,
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Herbert | 2005-11-07 15:27:19 | "ANSI" misnomer (Re: Snapshot 08.01.0006 available for testing) |
Previous Message | Leendert Paul Diterwich | 2005-11-07 11:55:31 | Re: Bug with version 08.01.0100 ? |