Postgresql Table inheritance

[Robert]

Telerik ORM does not appear to support table inheritance in postgresql?
I created two tables as below:

CREATE TABLE registered_student
(
  "ID" integer NOT NULL DEFAULT nextval('"registered_student_studentID_seq"'::regclass),
  CONSTRAINT registered_student_pkey PRIMARY KEY ("ID")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE registered_student
  OWNER TO boss;


CREATE TABLE student
(
  "ID" serial NOT NULL,
  firstname character varying(50),
  othername character varying(50),
  surname character varying(50),
  birthdate date,
  CONSTRAINT student_pkey PRIMARY KEY ("ID")
)
INHERITS (registered_student)
WITH (
  OIDS=FALSE
);
ALTER TABLE student
  OWNER TO boss;

This kind of relationship does not show up when importing the database into the ORM designer. Any ideas anyone?

[Damyan Bogoev]

Hi Robert,

I am afraid this is not a supported scenario at the moment, to create inheritance between persistent types based on PostgreSQL table inheritance information. You could model it later on using the visual designer. This article show how to do that.

You could add a feature request in our ideas and feedback portal regarding this case.

Should you have any other questions, do not hesitate to contact us back.

Regards,
Damyan Bogoev
Telerik