Entity Modeler has almost nothing to do with SQL generation ... It's
simply calling EOF using your selected plugin to do it. In this case,
this is a bug in the Project Wonder PostgresqlPlugIn.
ms
On Feb 7, 2009, at 2:09 PM, Jean Pierre Malrieu wrote:
> 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:26:39 EST