db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Tilsted (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TORQUE-323) Error in schema.xml for cascade="none" with postgresql
Date Sun, 10 Aug 2014 19:28:11 GMT
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message