[
https://issues.apache.org/jira/browse/TORQUE-323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14145667#comment-14145667
]
Thomas Fox commented on TORQUE-323:
-----------------------------------
Note: in current trunk the schema locateion has changed:
xsi:schemaLocation="http://db.apache.org/torque/4.0/templates/database
http://db.apache.org/torque/torque-4.0/documentation/orm-reference/database-4-0.xsd";
> 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
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
