"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