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
>> 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
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 !
In response to
pgsql-odbc by date
|Next:||From: Zahid Khan||Date: 2009-05-11 09:33:55|
|Subject: psqlodbc driver issue |
|Previous:||From: Hiroshi Inoue||Date: 2009-05-06 09:13:46|
|Subject: Re: INSERT on MSAccess linked ODBC table : out of memory|