Devart Forums

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.

Also using PostgreSqlDirect 2.10.

Just kidding, I didn't realize this was a demo software.

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.