db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Levitt (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-115) BEFORE triggers missing from CREATE TRIGGER documentation
Date Fri, 17 Jun 2005 23:23:17 GMT
     [ http://issues.apache.org/jira/browse/DERBY-115?page=all ]

Jeff Levitt updated DERBY-115:

    Attachment: derby115.zip

Attached patch fixes the syntax, adds NO CASCADE BEFORE, and mentions Before triggers in two
additional places in the topic where it used to just mention After triggers.  Please see attached
output in html for review, and provide either feedback or a thumbs up so we can get the changes
commited.  Thanks!

> BEFORE triggers missing from CREATE TRIGGER documentation
> ---------------------------------------------------------
>          Key: DERBY-115
>          URL: http://issues.apache.org/jira/browse/DERBY-115
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions:
>     Reporter: Daniel John Debrunner
>     Priority: Minor
>  Attachments: derby115.zip
> Derby does support before triggers, syntax is the same as after triggers,
> but replace AFTER with NO CASCADE BEFORE. Eg.
> create trigger t1
> NO CASCADE BEFORE insert on x
> referencing new_table as newrowtab
> for each statement mode db2sql
> insert into y select x from newrowtab;

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message