Uploaded image for project: 'DdlUtils'
  1. DdlUtils
  2. DDLUTILS-39

Creating Foreign Keys before creating the matching Tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.0 RC1
    • Core - PostgreSql
    • None
    • Windows 2000, XP, Linux, Eclipse, PostgreSQL, hsqldb, MySQL

    Description

      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?

      Attachments

        1. lakon-db-neu.xml
          13 kB
          Robert Einsle
        2. lakon-db.xml
          13 kB
          Robert Einsle

        Activity

          People

            tomdz Thomas Dudziak
            reinsle Robert Einsle
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: