db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thoralf Rickert (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-45) Generated SQL is in wrong order when dropping tables on table re-creation
Date Mon, 17 Jul 2006 11:20:15 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-45?page=comments#action_12421580 ] 
Thoralf Rickert commented on TORQUE-45:

> So how are tables with circular references dropped? 

I have this circular references problem in one of my schemes. And my solution is to drop the
whole database. 

This isn't a problem in a development environment (it's faster) and later in a production
environment you don't drop tables.

> 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.2, 3.1.1
>         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

View raw message