ConstraintException

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
[email protected]

ConstraintException

Post by [email protected] » 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.

[email protected]

Post by [email protected] » Tue 14 Jun 2005 16:10

Also using PostgreSqlDirect 2.10.

[email protected]

Post by [email protected] » Tue 14 Jun 2005 16:20

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

Yuri
Posts: 140
Joined: Mon 08 Nov 2004 12:07

ConstraintException

Post by 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.

Post Reply