This is a migrated thread and some comments may be shown as answers.

PostgreSQL Mapping with custom types

6 Answers 207 Views

Data Access Free Edition

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Sebastian SWC asked on 17 Jan 2011, 12:04 AM

Hy, sorry for my poor english.

I'm trying to use OpenAcess with PostgreSQL. My database have just only a table with a custom type.

Table definition:

CREATE TABLE test

(

id serial NOT NULL,

myarray integer[],

mycontrol custom_control,

CONSTRAINT test_pk PRIMARY KEY (id)

);

My custom_control Definition:

CREATE TYPE custom_control

AS (

dt_modify timestamp without time zone,

obs character varying(50)

);

After create a new domain model and try to see the table table on a radgrid, the following error occours:

Server Error in '/' Application.

No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Telerik.OpenAccess.Exceptions.MetadataException: No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped.

Any idea what i have to do to solve this problem?

PostgreSQL Mapping with custom types

Server Error in '/' Application.

No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped.

6 Answers, 1 is accepted