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

Hiroshi Inoue a écrit :
> postgresqlodbc.domain.thewild_codata@spamgourmet.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" ?
I could not find this in the documentation, but this is a guess from an
automatically generated file-DSN.

Thanks a lot for your answer Hiroshi !

Regards
Arnaud