Re: Does psqlodbc support declare/fetch in Un ux? - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Does psqlodbc support declare/fetch in Un ux?
Date
Msg-id 20060720070953.GA3797@soptik.pzkagis.cz
Whole thread Raw
In response to Does psqlodbc support declare/fetch in Un ux?  ("王宝兵" <wbbwisdom@163.com>)
List pgsql-odbc
> There are 1532240 tuples in pg_largeobject, and their size is about
> 3GB. But where I run this code, the client's main memory is exhausted.
> It seems that the client try to get all the tuples before it fetches
> the first 100.
>
> What's wrong? How can I fixed it?

What connection string? What's the settings in odbc.ini?
The first question is if you are using declare/fetch.

Could you send us the mylog output?

Regards,

Luf

pgsql-odbc by date:

Previous
From: Antoine
Date:
Subject: update field with lf chars problem
Next
From: Ludek Finstrle
Date:
Subject: Re: update field with lf chars problem