On 1/9/06, Alessandro Baretta <[EMAIL PROTECTED]> 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 ;)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
