Re: EM generating bad SQL for constraints and indexes (Postgresql)

From: Mike Schrag (mschra..dimension.com)
Date: Wed Mar 26 2008 - 13:02:34 EDT

  • Next message: jp.malrie..ree.fr: "Re: EM generating bad SQL for constraints and indexes (Postgresql)"

    Are you using 5.4? 5.4 has a bug that causes SQL generation to not
    properly call through the plugin.

    ms

    On Mar 26, 2008, at 12:58 PM, jp.malrie..ree.fr wrote:

    > 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:03:48 EDT