diff options
| author | lpsolit%gmail.com <> | 2009-01-05 20:52:06 +0100 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2009-01-05 20:52:06 +0100 |
| commit | 06ffbf7ddc8af6be60266e6e3afdd05cfb373224 (patch) | |
| tree | a940cd3465c16cf246cbebeff69b456387c95991 | |
| parent | a8cc91bfe25645ff5d83d1732109533688872196 (diff) | |
| download | bugzilla-06ffbf7ddc8af6be60266e6e3afdd05cfb373224.tar.gz bugzilla-06ffbf7ddc8af6be60266e6e3afdd05cfb373224.tar.xz | |
Bug 472013: [Oracle] checksetup.pl fails with ORA-04091 and you can't change the properties of custom fields - Patch by Xiaoou <xiaoou.wu@oracle.com> r/a=mkanat
| -rw-r--r-- | Bugzilla/DB/Oracle.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/DB/Schema/Oracle.pm | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm index 4153751fd..ee150c024 100644 --- a/Bugzilla/DB/Oracle.pm +++ b/Bugzilla/DB/Oracle.pm @@ -558,7 +558,7 @@ sub bz_setup_database { } my $tr_str = "CREATE OR REPLACE TRIGGER $trigger_name" - . " AFTER UPDATE ON ". $to_table + . " AFTER UPDATE OF $to_column ON $to_table " . " REFERENCING " . " NEW AS NEW " . " OLD AS OLD " diff --git a/Bugzilla/DB/Schema/Oracle.pm b/Bugzilla/DB/Schema/Oracle.pm index bd5c72476..8332be707 100644 --- a/Bugzilla/DB/Schema/Oracle.pm +++ b/Bugzilla/DB/Schema/Oracle.pm @@ -152,7 +152,7 @@ sub get_fk_ddl { if ( $update =~ /CASCADE/i ){ my $tr_str = "CREATE OR REPLACE TRIGGER ${fk_name}_UC" - . " AFTER UPDATE ON ". $to_table + . " AFTER UPDATE OF $to_column ON $to_table " . " REFERENCING " . " NEW AS NEW " . " OLD AS OLD " |