db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Carter (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-45) Generated SQL is in wrong order when dropping tables on table re-creation
Date Mon, 17 Jul 2006 09:40:13 GMT
Generated SQL is in wrong order when dropping tables on table re-creation
-------------------------------------------------------------------------

                 Key: TORQUE-45
                 URL: http://issues.apache.org/jira/browse/TORQUE-45
             Project: Torque
          Issue Type: Bug
          Components: Generator
    Affects Versions: 3.1.1, 3.2
         Environment: java 1.4.2, 1.5. Solaris 10.
            Reporter: Joe Carter


When the table creation SQL is re-run when the schema contains foreign keys, you will get
referential integrity complaints.
This is because the table drop order means that it tries to drop dependent tables first.
To fix this, the drop statements should be before all the creates. They should also be in
reverse order to the creates.
A method to be able to obtain the tables in reverse order will be needed to allow the templates
to be modified to fix this.

-- 
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

        

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message