Re: Out of memory with ODBC

Relyea, Mike wrote:
> I tried posting this to the OBC list but didn't get any responses, so
> I'm trying my luck here.
>
>> I'm receiving an out of memory error when trying to execute a long,
>> complex query involving many temp tables.  I'm using psqlODBC ver
>> 8.02.0500 and PG 8.2.4 on WinXP.  I'm trying to execute this query via
>> a pass-through query in MS Access 2003.  If I execute this query in
>> PGAdmin III it runs without any errors and returns no records.

Hmm. So what's different about the queries?

>> My connection string in Access is:
>> ODBC; DRIVER={PostgreSQL Unicode}; SERVER=myServer; DATABASE=iqdb;
>> PORT=5432; UID=myUserName; PWD=xxxxxxx; B9=0; B7=1; B3=1; C8=1
>>
>> I've attached the log file which contains the SQL I'm trying to
>> execute and the error details.  I've tried setting UseDeclareFetch = 1
>
>> but it didn't resolve the error.  Any suggestions?

[145.188]ERROR from backend during send_query: 'SERROR'
[145.188]ERROR from backend during send_query: 'C53200'
[145.188]ERROR from backend during send_query: 'Mout of memory'
[145.188]ERROR from backend during send_query: 'DFailed on request of
size 16.'
[145.188]ERROR from backend during send_query: 'Faset.c'
[145.188]ERROR from backend during send_query: 'L712'
[145.188]ERROR from backend during send_query: 'RAllocSetAlloc'

OK, so this seems to be a server-side error, which means something
should be in the server logs. Is there anything?

Oh, and I'd probably split that query into about a dozen smaller ones -
one per statement.
--
   Richard Huxton
   Archonet Ltd