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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
