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