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