Updates with user defined parameter types does not work

Updates with user defined parameter types does not work

Postby slaughter » Fri 16 Sep 2005 12:55

I defined Domain type as

Code: Select all
CREATE DOMAIN "public"."udt_namealias" AS
  varchar(16) NULL;

ALTER DOMAIN "public"."udt_namealias"
  ADD CHECK ((VALUE)::text ~ '^\w.*$'::text);


and table with column of this (udt_namealias) type.

Now when trying to do PgSqlDataAdapter.Update on a relevant dataset, the error "Cannot convert value" appears. No matter if CommanBuilder is used or parameters specified manualy as Varchar(16). On the same table with explicitly specified data types as Varchar everything works fine.

Can you help?
slaughter
 
Posts: 1
Joined: Fri 16 Sep 2005 12:36

Updates with user defined parameter types does not work

Postby Yuri » Thu 22 Sep 2005 09:43

We reproduced this problem and fixed it.
This fix will be included in the next PostgreSqlDirect .NET build.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL