Out of memory troubles with version 8.01.01.02 - Mailing list pgsql-odbc

From Filip Wuytack
Subject Out of memory troubles with version 8.01.01.02
Date
Msg-id 439E948B.1080703@wuytack.net
Whole thread Raw
Responses Re: Out of memory troubles with version 8.01.01.02  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
Hi All,

I'm trying to fetch a table (simple select * from table) which is 102
columns and some 3.5 million rows. When running this I always end up
having a "out of memory". (when I put a where statement or a limit in the
SQL, it runs fine). I've tried tweaking the settings for the odbc setting
in windows (is windows xp) and upgraded to version  8.01.01.02 (even tried
to 103 snapshot), but the problem remains. I've attached both log files
created by the odbc driver. I hope someone can give me some hints on way
this is happening. I'm accessing the odbc dsn from within SAS 9.1.

Many thanks,

Filip


Attachment

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Access violation C5 error on Visual FoxPro SQLEXEC() call after error
Next
From: Ludek Finstrle
Date:
Subject: Re: Out of memory troubles with version 8.01.01.02