Icon View Incident Report

Minor Minor
Reported By: Fernando Dias
Reported On: 8/21/2008
For: Version 2.01 Build 4
# 2762 Reverse-Engineering Converts RESTRICT Foreign Key Constraint Actions to NO ACTION

1. The manual says NO ACTION is the same as RESTRICT in EDB and also says the only option available for referential actions is RESTRICT, so what I conclude is that indicating NO ACTION (by not indicating the referential action) has the same effect of indicating RESTRICT, and both alternatives are interpreted by EDB as RESTRICT and not as NO ACTION.

2. Although both have the same effect, EDB preserves the specified option when tables are created and EDB Manager offers both options when creating and altering tables.

3. Reverse engineering is not following the rule above : it reverts all RESTRICT actions to NO ACTION, so if you create the tables indicating RESTRICT and then use reverse engineering to recreate the database, you will end up with all tables with NO ACTION.

Resolution Resolution
Fixed Problem on 8/22/2008 in version 2.01 build 5

Products Affected Products Affected
ElevateDB Additional Software and Utilities