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

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 04:51:32
Message-ID: 4A011754.1010800@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2009-05-06 06:13:21
Subject: Re: DataDirect Driver, ExecDirect and UTF-8
Previous:From: Adam RuthDate: 2009-05-05 20:47:52
Subject: Re: Unsupported Type UUID

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