Bug 76877

Summary: Exporting SQL code, order of tables and foreign keys
Product: [Applications] umbrello Reporter: Jaakko Holster <holster>
Component: generalAssignee: Umbrello Development Group <umbrello-devel>
Status: RESOLVED DUPLICATE    
Severity: wishlist    
Priority: LO    
Version: 1.2   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In:

Description Jaakko Holster 2004-03-06 12:11:08 UTC 
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.
Comment 1 Jonathan Riddell 2004-03-15 23:32:49 UTC 

*** This bug has been marked as a duplicate of 77377 ***