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: 1806D1F73FCB7F439F2C842EE0627B1806AE3C6A@USA0300MS01.na.xerox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Attachment Content-Type Size
psqlodbc_3888.zip application/x-zip-compressed 5.4 KB

Responses

Browse pgsql-odbc by date

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