I'm having a problem where, for most queries, a System.Data.ConstraintException is thrown with the error "Column xyz exceeds the MaxLength limit". For most queries I can catch the error and continue normally without any problem. However this only works for queries with small numbers of columns - for larger queries the resulting DataTable has null values in most of the columns.
I think this might be related to string values, as queries that only involve numerical or date data don't cause any exception to be thrown. I am using "text" as the datatype for all my string data.
I am running Windows 2000, .NET FrameWork 1.1.4322, PostgreSql 8.01.
Any help would be appreciated, thanks.
ConstraintException
ConstraintException
We reproduced problem with "text" datatype and fixed it. This fix will be included in the next PostgreSQLDirect .NET build.
It will be available in about two weeks.
It will be available in about two weeks.