EM generating bad SQL for constraints and indexes (Postgresql)

From: jp.malrie..ree.fr
Date: Wed Mar 26 2008 - 12:58:48 EDT

  • Next message: Mike Schrag: "Re: EM generating bad SQL for constraints and indexes (Postgresql)"

    Hi,

    I am trying to use EntityModeler to setup a postgresql database. I am prefixing
    the table names by their schema (eg: "notes.staffmeeting"). When I generate the
    sql from EM, the generated sql contains prefixed names for constraints and
    indexes:

    ALTER TABLE notes.Period ADD CONSTRAINT notes.Period_pk PRIMARY KEY (id);
    CREATE INDEX notes.ReportCard_classAssessmentID_idx ON notes.ReportCard(
    classAssessmentID );

    In postgresql syntax, these are not valid names for constraints and indexes
    (they ought not be prefixed). So SQL execution fails.

    I don't know if EM is responsible for this, or the postgresql plugin (from
    Wonder). Should I file a bug about this issue?

    Thanks.

    JPM

    This archive was generated by hypermail 2.0.0 : Wed Mar 26 2008 - 13:00:15 EDT