From: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Out of memory with ODBC |
Date: | 2007-10-12 13:53:05 |
Message-ID: | 1806D1F73FCB7F439F2C842EE0627B1806BF1955@USA0300MS01.na.xerox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
> 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?
Mike
Attachment | Content-Type | Size |
---|---|---|
log.zip | application/x-zip-compressed | 5.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-10-12 14:05:32 | Re: how to truncate/purge the pg_xlog directory? |
Previous Message | Tomi N/A | 2007-10-12 13:46:29 | pg_dump - schema diff compatibility |