Thread: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc

migrating MSAccess to pgsql7.0 on RH 6.2 through odbc

From
"Poul Kristensen"
Date:
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
 

Re: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc

From
"Poul L. Christiansen"
Date:
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
>

Re: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc

From
Tom Lane
Date:
"Poul L. Christiansen" <poulc@cs.auc.dk> writes:
>> 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".

> 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.

There is no such error message in the 7.0 backend.  I think the ODBC
driver still believes that there is an 8K limit on query strings, and
it is helpfully preventing you from issuing the query :-(.  There isn't
anyone actively maintaining the ODBC driver right now, AFAIK, so I don't
know when that silliness will be fixed.

            regards, tom lane