[ 
https://issues.apache.org/jira/browse/TORQUE-323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Martin Tilsted updated TORQUE-323:
----------------------------------

    Description: 
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.


  was:
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 have been specified on all foreign keys.



> 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.2#6252)

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org

Reply via email to