Page 1 of 1

Constraint error with PgSqlDataTable

Posted: Tue 14 Jun 2005 15:12
by KenK
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

Constraint issue with type text

Posted: Wed 15 Jun 2005 13:50
by KenK
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

Posted: Thu 16 Jun 2005 11:16
by Yuri
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.