[ http://issues.apache.org/jira/browse/DDLUTILS-39?page=all ]
Robert Einsle updated DDLUTILS-39:
----------------------------------
Attachment: lakon-db-neu.xml
This is the second XML-File with an additional Table an an Foreign Key refering
to this Table. The new Table is "einsatzarten" an an Foreign Key from
"einsaetze" to "einsatzarten".
> Creating Foreign Keys before creating the matching Tables
> ---------------------------------------------------------
>
> Key: DDLUTILS-39
> URL: http://issues.apache.org/jira/browse/DDLUTILS-39
> Project: DdlUtils
> Type: Bug
> Environment: Windows 2000, XP, Linux, Eclipse, PostgreSQL, hsqldb, MySQL
> Reporter: Robert Einsle
> Assignee: Thomas Dudziak
> Priority: Minor
> Attachments: lakon-db-neu.xml, lakon-db.xml
>
> While testing on an Postgres-Database, we have the Problem DDL-Utils works
> thrait throu the xml-Inputfile, and alters the Database. But we have an
> definition of an foreign key insertet in an table above the creation-rule of
> the table itself. So, DDL-Utils first tries to alter the Database, inserting
> the Foreign-key, fails, then creates the table. So, we have 2 choices,
> sorting the xml-inputfile for the foreign keys, or DDL-Utils let to create
> foreign keys after creating the needed Tables. For my choices i would prefer
> the second solution. Can i do anything other?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
