Re: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc - Mailing list pgsql-novice

From Poul L. Christiansen
Subject Re: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc
Date
Msg-id 3A09D6AD.3D516F91@cs.auc.dk
Whole thread Raw
In response to migrating MSAccess to pgsql7.0 on RH 6.2 through odbc  ("Poul Kristensen" <bcc5226@vip.cybercity.dk>)
Responses Re: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
You can try to use PgAdmin to upsize instead:
http://www.greatbridge.org/project/pgadmin/download/download.php

But maybe the error comes if you try to insert a record that is larger
than 8kb, which is the upper limit in 7.0.

7.1 doesn't have this limit.

Hilsen
Poul L. Christiansen

> Poul Kristensen wrote:
>
> Hej
>
> I have succesfully migrated 28 tables in MSaccess to Pgsql 7.0 on
> RH6.2 through ODBC.
>
> I have to migrate 2 more tables, but get the message "Query string is
> to long".
>
> I have tried to raise the values in the OBDC configuration, but it
> does't
> seem to work.
>
> What else can I do?
>
> TIA
>
> Poul
>

pgsql-novice by date:

Previous
From: "Poul Kristensen"
Date:
Subject: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc
Next
From: Charles Curley
Date:
Subject: Re: Re: [GENERAL] VACUUM AND VACUUM ANALYSE