[Uml-devel] [Bug 76877] New: Exporting SQL code, order of tables and foreign keys
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
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