Constraint error with PgSqlDataTable

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
KenK

Constraint error with PgSqlDataTable

Post by KenK » Tue 14 Jun 2005 15:12

I've typed in the example given in the help file for PgSqlDataTable, and when I run it, I get the following error:

An unhandled exception of type 'System.Data.ConstraintException' occurred in system.data.dll

Additional information: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

I'm using the Demo version and would like to know if this is a limitation of the demo, and will this go away with the full version?

Please help!
Ken

KenK

Constraint issue with type text

Post by KenK » Wed 15 Jun 2005 13:50

I changed my tables field types from 'text' to 'char', and the problem went away.

Does PostgreSQLDirect support the PostgreSQL 'TEXT' column type? If not, is it planned?

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

Constraint issue with type text

Post by Yuri » Thu 16 Jun 2005 11:16

We reproduced problem and fixed it. This fix will be included in the next PostgreSQLDirect .NET build.
It will be available in about two weeks.

Post Reply