Updates with user defined parameter types does not work

[slaughter]

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?

[Yuri]

We reproduced this problem and fixed it.
This fix will be included in the next PostgreSqlDirect .NET build.