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

Re: Out of memory error

From: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Out of memory error
Date: 2007-10-08 13:00:07
Message-ID: 1806D1F73FCB7F439F2C842EE0627B1806B7C4DE@USA0300MS01.na.xerox.net (view raw or flat)
Thread:
Lists: pgsql-odbc
> 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.
> 
> 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?
> 

Anybody have any suggestions on this?

In response to

pgsql-odbc by date

Next:From: Mark Cave-AylandDate: 2007-10-08 20:24:42
Subject: Re: Filtering ODBC table list
Previous:From: m.wetmore@secomintl.comDate: 2007-10-07 03:24:52
Subject: Re: Unable to update JOIN'ed recordset with PSQLODBC 08.02.0400 and ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group