[ 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: > ALTER TABLE book > ADD CONSTRAINT book_FK_1 > FOREIGN KEY (keyref) > REFERENCES keyreftable (id) > ON UPDATE NONE > ON DELETE NONE; > 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 (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org For additional commands, e-mail: torque-dev-h...@db.apache.org