Reposting the following from Wonder-disc to the right list:
Hi list,
i'm using postgresql and putting my tables, sequences... in a specific
schema
(not the public schema).
Thus I prefix all table names by the schema's name in the eomodel.
Entity Modeler generates wrong sql when it comes to primary keys and
indexes.
For example ("series" is the schema) :
ALTER TABLE series.Indicator ADD CONSTRAINT series.Indicator_pk
PRIMARY KEY
(id);
series.Indicator_pk is not a valid pk name for postgresql, removing
the prefix
corrects the problem.
There is the same problem with indexes but not with foreign keys,
foreign key
names are not prefixed when generated.
How can i tweak this sql generation thing ?
PS: that is with Eclipse 3.4 + WOLips 3.4.5578 (Wonder version is
irrelevant I guess)
-----------------------------------------------------------------------------------------------------------------------------------------------------------
@+
Alexis Tual
Développeur
Fylab
Parc Technologique du Canal
Campus II, Bâtiment A
3 avenue de l'Europe
31400 Toulouse
Tel : +33 5 62 47 00 39
Cell : +33 6 80 90 16 34
Fax : +33 5 62 47 00 36
http://www.fylab.fr
This archive was generated by hypermail 2.0.0 : Sat Feb 07 2009 - 14:10:09 EST