db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (TORQUE-323) Error in schema.xml for cascade="none" with postgresql
Date Wed, 24 Sep 2014 00:10:33 GMT

     [ https://issues.apache.org/jira/browse/TORQUE-323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Thomas Fox resolved TORQUE-323.
    Resolution: Cannot Reproduce
      Assignee: Thomas Fox

I cannot reproduce the described behaviour. Please feel free to reopen the issue with an attached
exmple schema and generation configuration with which the problem can be reproduced.

> Error in schema.xml for cascade="none" with postgresql
> ------------------------------------------------------
>                 Key: TORQUE-323
>                 URL: https://issues.apache.org/jira/browse/TORQUE-323
>             Project: Torque
>          Issue Type: Bug
>    Affects Versions: 4.0
>         Environment: Postgresql 9.3.4 Java 8, on 64bit x86 Fedora.
>            Reporter: Martin Tilsted
>            Assignee: Thomas Fox
> If you in your schema.xml have a
> <foreign-key onUpdate="none" ...>
> Then torque will generate the following in schema.sql: 
>     ADD CONSTRAINT book_FK_1
>     FOREIGN KEY (keyref)
>     REFERENCES keyreftable (id)
> But postgresql don't accept the syntax "On update none" and "on delete none"
> It should be "on update no action" and "on delete no action" instead.
> Since onUpdate="none" is the default if no onUpdate value have been set in schema.xml,
this make it imposible to generate the database from the sql, unless onUpdate and onDelete
explicit have been specified to something other then none on all foreign keys.

This message was sent by Atlassian 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