Bug 76877 - Exporting SQL code, order of tables and foreign keys
Summary: Exporting SQL code, order of tables and foreign keys
Status: RESOLVED DUPLICATE of bug 77377
Alias: None
Product: umbrello
Classification: Applications
Component: general (show other bugs)
Version: 1.2
Platform: unspecified Linux
: LO wishlist
Target Milestone: ---
Assignee: Umbrello Development Group
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-06 12:11 UTC by Jaakko Holster
Modified: 2004-03-15 23:32 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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 ***