Constraint error with PgSqlDataTable

Constraint error with PgSqlDataTable

Postby 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

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!

Constraint issue with type text

Postby 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?

Constraint issue with type text

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

Return to dotConnect for PostgreSQL