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

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: postgresqlodbc(dot)domain(dot)thewild_codata(at)spamgourmet(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: INSERT on MSAccess linked ODBC table : out of memory
Date: 2009-05-06 09:13:46
Message-ID: 4A0154CA.10704@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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:
>>> Hi all !
>>>
>>> I have a MSAccess 2007 frontend with linked tables on a PostgreSQL
>>> 8.3.7 backend.
>>> The tables are linked via ODBC with the PsqlODBC 8.03.0400 driver.
>>> I use the driver's default options.
>>>
>>> I am trying to run a query that inserts ~350.000 rows from a local
>>> Access table to a linked PostgreSQL table. Both tables have the same
>>> structure, so the statement is basically something like :
>>> INSERT INTO mylinkedtable (field1, field2, etc...) SELECT field1,
>>> field2, etc... FROM myaccesstable;
>>> The table on the postgresql server is quite simple, no trigger or
>>> rule, only a primary key and 3 indexes (btree).
>>>
>>> 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" ?

Yes.
This problem seems closely related to the topic
http://archives.postgresql.org/pgsql-general/2009-04/msg00728.php
.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message postgresqlodbc.domain.thewild_codata 2009-05-06 09:58:40 Re: INSERT on MSAccess linked ODBC table : out of memory
Previous Message postgresqlodbc.domain.thewild_codata 2009-05-06 06:47:10 Re: INSERT on MSAccess linked ODBC table : out of memory