| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Out of memory with ODBC |
| Date: | 2007-10-12 17:01:35 |
| Message-ID: | 470FA86F.8080000@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
>> Hmm - I can't think how that could reach 1.9GB in size, especially since
>> it has to be something different between a "raw" connection and how ODBC
>> is doing things.
>
> Try turning on log_statement to see what's really being executed.
> I seem to recall reading that Access thinks it can mangle your SQL
> as it sees fit.
Hmm - Mike said it was a pass-through query which should be safe. Also,
the odbc log should have accurate SQL in it.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo De León | 2007-10-12 17:05:04 | Re: Query problem |
| Previous Message | Filip Rembiałkowski | 2007-10-12 16:59:42 | Re: DB errors |