ConstraintException

ConstraintException

Postby mcallen@umich.edu » Tue 14 Jun 2005 16:08

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.
mcallen@umich.edu
 

Postby mcallen@umich.edu » Tue 14 Jun 2005 16:10

Also using PostgreSqlDirect 2.10.
mcallen@umich.edu
 

Postby mcallen@umich.edu » Tue 14 Jun 2005 16:20

Just kidding, I didn't realize this was a demo software.
mcallen@umich.edu
 

ConstraintException

Postby Yuri » Thu 16 Jun 2005 11:34

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.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL