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

Out of memory error

From: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Out of memory error
Date: 2007-10-01 23:48:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Repost with zipped attachment.  First post never showed up?

> 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?

Description: application/x-zip-compressed (5.4 KB)


pgsql-odbc by date

Next:From: Dmitry SamokhinDate: 2007-10-02 10:21:53
Subject: Re: Unable to update JOIN'ed recordset with PSQLODBC 08.02.0400 and ADO
Previous:From: Mija LeeDate: 2007-10-01 23:23:21
Subject: Re: problems accessing utf8 encoded databases

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