You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2006/07/30 07:21:16 UTC

[jira] Resolved: (DDLUTILS-39) Creating Foreign Keys before creating the matching Tables

     [ http://issues.apache.org/jira/browse/DDLUTILS-39?page=all ]

Thomas Dudziak resolved DDLUTILS-39.
------------------------------------

    Resolution: Fixed

> Creating Foreign Keys before creating the matching Tables
> ---------------------------------------------------------
>
>                 Key: DDLUTILS-39
>                 URL: http://issues.apache.org/jira/browse/DDLUTILS-39
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - PostgreSql
>         Environment: Windows 2000, XP, Linux, Eclipse, PostgreSQL, hsqldb, MySQL
>            Reporter: Robert Einsle
>         Assigned To: Thomas Dudziak
>            Priority: Minor
>             Fix For: 1.0
>
>         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