[
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
