Skip site navigation (1) Skip section navigation (2)

Re: INSERT on MSAccess linked ODBC table : out of memory

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Zahid KhanDate: 2009-05-11 09:33:55
Subject: psqlodbc driver issue
Previous:From: Hiroshi InoueDate: 2009-05-06 09:13:46
Subject: Re: INSERT on MSAccess linked ODBC table : out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group