From: | postgresqlodbc(dot)domain(dot)thewild_codata(at)spamgourmet(dot)com |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: INSERT on MSAccess linked ODBC table : out of memory |
Date: | 2009-05-06 09:58:40 |
Message-ID: | 4A015F50.1080401@codata.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hiroshi Inoue a écrit :
> postgresqlodbc(dot)domain(dot)thewild_codata(at)spamgourmet(dot)com wrote:
>> Hiroshi Inoue a écrit :
>>> postgresqlodbc(dot)domain(dot)thewild_codata(at)spamgourmet(dot)com wrote:
>>>> I am trying to run a query that inserts ~350.000 rows from a local
>>>> Access table to a linked PostgreSQL table.
>>>> This query runs for quite a long time (10 minutes) and fails before
>>>> the end.
>>>> Access only shows me an "ODBC failure" message.
>>>> On the postgresql server (backend), I have an "ERROR: out of memory
>>>> DETAIL: Failed on request of size 560".
>>>
>>> Please set the *Level of rollback on errors* Datasource option to
>>> *Transaction* if you are setting the option to *Statement*.
>>> You also have to relink the link table after changing the Datasource
>>> setting.
>>
>> Is this done by setting "protocol" to 7.4-1 ? And a value of 7.4-2 is
>> for "statement" ?
>
> This problem seems closely related to the topic
> http://archives.postgresql.org/pgsql-general/2009-04/msg00728.php
Yes, that's exactly what I am seeing here.
Strange that this is not considered as a bug, but my understanding of
postgresql's internals is very limited.
Anyway, protocol=7.4-1 fixed this !
Thanks for your help !
Regards
--
Arnaud
From | Date | Subject | |
---|---|---|---|
Next Message | Zahid Khan | 2009-05-11 09:33:55 | psqlodbc driver issue |
Previous Message | Hiroshi Inoue | 2009-05-06 09:13:46 | Re: INSERT on MSAccess linked ODBC table : out of memory |