Martin Tilsted created TORQUE-323:
-------------------------------------
Summary: 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 a
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 have been specified on all foreign keys.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
