On 1/9/06, Alessandro Baretta <a.baretta@xxxxxxxxxxxxxxx> wrote: > Hello gentlemen, > > Although this is my first post on the list, I am a fairly experienced PostgreSQL > programmer. I am writing an ERP application suite using PostgreSQL as the > preferred DBMS. Let me state that the SQL DDL is automatically generated by a > CASE tool from an ER model. The generated schema contains the appropriate > primary key and foreign key constraints, as defined by the original ER model, as > well as "reverse indexes" on foreign keys, allowing (in theory) rapid backward > navigation of foreign keys in joins. > > Let me show a sample join of two tables in the database schema. The information > provided is quite extensive. I'm sorry for that, but I think it is better to > provide the list with all the relevant information. > > Package: postgresql-7.4 maybe, because you are in developing state, you can start to think in upgrading to 8.1 -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
