[Uml-devel] [Bug 76877] New: Exporting SQL code, order of tables and foreign keys

Jaakko Holster holster at iki.fi
Sat Mar 6 14:37:01 UTC 2004

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
           Summary: Exporting SQL code, order of tables and foreign keys
           Product: umbrello
           Version: 1.2
          Platform: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: general
        AssignedTo: umbrello-devel.kde.org
        ReportedBy: holster iki fi

Version:           1.2 (using KDE 3.2.0, Gentoo)
Compiler:          gcc version 3.2.3 20030422 (Gentoo Linux 1.4 3.2.3-r1, propolice)
OS:          Linux (i686) release 2.6.2

Generating code from SQL class diagrams makes a file for each table. However, if I try to create tables by 'psql < *.sql', not all tables can be created, because a table may have a foreign key referencing to another table, but the referenced table has not been created yet. To fix this problem, SQL code generator should put all the code into one file and intelligently order tables so that tables with foreign key are placed after their reference tables.

More information about the umbrello-devel mailing list