Postgresql Table inheritance

2 posts, 0 answers
  1. Robert
    Robert avatar
    1 posts
    Member since:
    May 2013

    Posted 23 Sep 2013 Link to this post

    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?

  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 25 Sep 2013 Link to this post

    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
    OpenAccess ORM Q3 2013 Beta is available for immediate download in your account. Get it now and play with the latest bits. See what's new >>
  3. DevCraft banner
Back to Top