From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com> |
Cc: | "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Server Side Cursors. |
Date: | 2001-11-22 02:16:49 |
Message-ID: | 3BFC6011.1559E115@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
"Ryan C. Bonham" wrote:
>
> Hiroshi,
>
> Here is some more information..
>
> > What cursor type are you using ?
>
> Working setup is:
> Client Side Cursors Location, Static cursor type, and Optimistic Locking.
>
> The Following setups return only 8 records out of 5110:
> Server Side Cursors Location, Static cursor type, and Optimistic Locking.
> Server Side Cursors Location, Keyset cursor type, and Optimistic Locking.
> Server Side Cursors Location, Static cursor type, and Pessimistic Locking.
> Server Side Cursors Location, Keyset cursor type, and Pessimistic Locking.
> Server Side Cursors Location, Static cursor type, and ReadOnly Locking.
>
> The following return 0 records:
> Server Side Cursors Location, Dynamic cursor type, and Optimistic Locking.
> Server Side Cursors Location, forward-only cursor type, and ReadOnly Locking.
> Server Side Cursors Location, Dynamic cursor type, and Pessimistic Locking.
> Server Side Cursors Location, Dynamic cursor type, and ReadOnly Locking.
>
> The Select command the dataenvironment is using is;
> select * from bloods where date is not null order by date desc
Here I can see that Dynamic cursors return no row but
Keyset/Static cursors seem to return proper results for
some simple test cases.
Anyway the current psqlodbc driver itself supports only
ForwardOnly/Static cursors with ReadOnly locking. Oh,
they don't return proper results either. Hmm strange..
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-11-22 16:02:12 | Re: Question |
Previous Message | Hiroshi Inoue | 2001-11-22 00:20:07 | Re: Unknown connect option while using IDL |