summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2009-01-05 20:52:06 +0100
committerlpsolit%gmail.com <>2009-01-05 20:52:06 +0100
commit06ffbf7ddc8af6be60266e6e3afdd05cfb373224 (patch)
treea940cd3465c16cf246cbebeff69b456387c95991
parenta8cc91bfe25645ff5d83d1732109533688872196 (diff)
downloadbugzilla-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.pm2
-rw-r--r--Bugzilla/DB/Schema/Oracle.pm2
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 "