I don't know what the problem is, but I would suspect
some weirdness in Access.
For exporting from Access to PostgreSQL, I suggest you
take a look at the "Database Migration Wizard" that
comes with PgAdminII (but not yet PgAdminIII,
regrettably). I have had good experiences using that
wizard, which transparently does things like creating
appropriate sequences for your "autonumber" columns,
and creating referential integrity relationships based
on your Access setup.
--- Ken-ichi <kueda(at)nature(dot)berkeley(dot)edu> wrote:
> Hi folks. I tried searching this list's archives
> for this problem but
> came up short. I have a fairly large table in MS
> Access 2000 (33 cols,
> 3270 rows) that I'm trying to export to PostgreSQL
> 7.4.3. When I clip
> the table to only about 100 rows, the export runs
> fine, but when I try
> to export the whole thing, I get an error window
> that says only
> "Overflow." This process generates the following
> error in my
> postgresql.log file:
> ERROR: relation "msysconf" does not exist
> The psqlodbc_xxxx.log written to my local machine
> ends with
> conn=124694520, query='ROLLBACK'
> conn=124694520, query='DROP TABLE "plot_data"'
> conn=124694520, PGAPI_Disconnect
> And the mylog_xxxx.log file doesn't seem to mention
> overflow anywhere,
> but it does contain the lines
> **** PGAPI_ExecDirect: hstmt=131080744,
> statement='DROP TABLE
> PGAPI_ExecDirect: calling PGAPI_Execute...
> PGAPI_Execute: entering...
> PGAPI_Execute: clear errors...
> recycle statement: self= 131080744
> Exec_with_parameters_resolved: copying
> statement params:
> trans_status=1, len=22, stmt='DROP TABLE
>  stmt_with_params = 'DROP TABLE "plot_data"'
>  it's NOT a select statement:
> send_query(): conn=131086712, query='DROP
> TABLE "plot_data"'
> send_query: done sending query
> Can anyone tell me what's going on, and how to fix
> ---------------------------(end of
> TIP 6: Have you searched our list archives?
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
In response to
pgsql-odbc by date
|Next:||From: Scot Loach||Date: 2004-09-19 14:29:07|
|Subject: segfault when disconnecting from db with server side prepare|
|Previous:||From: mik||Date: 2004-09-17 09:32:39|
|Subject: SQLDescribeCol before SQLExcecute call problerm|