Ben Trewern wrote:
> All
>
> I've been using (or trying to use) the pgODBC driver with 'Use
> Declare/Fetch' set to true and all goes well till you try to go to the
> end of a large recordset. The driver seems to load all the records
> instead of just the last 50 (or whatever). I'm using Delphi 7, BDE and
> psqlODBC version 7.03.01.08 to connect to Postgres 7.3.1.
>
> Any ideas? Could this be a BDE problem? Any one else out there using
> this configuration?
>
> Regards,
>
> Ben
According to what I gather from the thread here:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=7159b632785c579f&seekm=3E1BEFFE.88B57516%40tpf.co.jp#link13
PostgreSQL cannot perform a backward-scan and is forced to materialize
the result set in its entirety. So that is a backend issue
specifically, not an ODBC issue, I'm afraid.
Mike Mascari
mascarm@mascari.com
