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

"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