460922 - [Oracle] Need to drop all the FKs before dropping tables.

Status: RESOLVED FIXED

(Bugzilla :: Database, defect)

Description

[Xiaoou]

Because there are triggers for UPDATE CASCADE, and the normal ' drop table ' will not work for this.

Comment 1

[Xiaoou]

Attachment: v1

Comment 2

[Max Kanat-Alexander]

3.2 doesn't drop any tables...well, except if you delete a custom field, I suppose. So I guess this is a blocker indeed, then.

Comment 3

[Max Kanat-Alexander]

Comment on attachment 344033 [details] [diff] [review]
v1

Okay, did you test this?

Also, aren't there other triggers that you're going to have to drop when you drop the table?

Comment 4

[Xiaoou]

Yeah. I've done the test.

And other triggers will be Okay.

Comment 5

[Xiaoou]

Other triggers will be Okay, because the triggers are on the table, when dropping the table, they will be dropped at the same time.

But when things come to FK, the triggers are on the reference table, which is not the table we drop.

Comment 6

[Frédéric Buclin]

tip:

Checking in Bugzilla/DB/Oracle.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Oracle.pm,v  <--  Oracle.pm
new revision: 1.17; previous revision: 1.16
done

3.2rc1:

Checking in Bugzilla/DB/Oracle.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Oracle.pm,v  <--  Oracle.pm
new revision: 1.6.2.8; previous revision: 1.6.2.7
done