Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Does psqlodbc support declare/fetch in Un ux?



> 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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group