View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000004 | Database Workbench v6 | Firebird Module | public | 2011-04-28 15:57 | 2022-01-12 13:19 |
| Reporter | sqldba | Assigned To | |||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Summary | 0000004: Ability to alter a domain when it used in a constraint/column | ||||
| Description | Database Workbench/Firebird does not have the ability to modify domains if it is used in a constraint. You cannot switch the underlying datatype nor change the length of the datatype. This defeats the whole purpose of using a domain. In a production system, this would mean dropping all the constraints, modifying a new domain, and manually creating all the constraints which is very tedious. No other database tool vendor for Firebird provides this feature (which is a very requested feature) and if Database Workbench implements this feature, it would be great. Example: CREATE DOMAIN test_domain VARCHAR(25); CREATE TABLE test_table ( test_column test_domain NOT NULL PRIMARY KEY ); ALTER DOMAIN test_domain VARCHAR(26); <-- Firebird throws error that the update was not successful because the domain is used in a constraint (primary key) | ||||
| Tags | No tags attached. | ||||
|
|
Basically, instead of manually dropping the constraints, modifying the domain etc.....Database Workbench should automate the process. |
|
|
Non-domained columns in tables also suffer from this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-04-28 15:57 | sqldba | New Issue | |
| 2011-04-28 15:58 | sqldba | Note Added: 0000001 | |
| 2011-05-02 09:28 | Martijn Tonies | Status | new => acknowledged |
| 2011-11-02 10:54 | Martijn Tonies | Note Added: 0000034 | |
| 2011-11-02 10:54 | Martijn Tonies | Priority | urgent => normal |
| 2011-11-02 10:54 | Martijn Tonies | Summary | Alter domain when it used in a constraint/column => Ability to alter a domain when it used in a constraint/column |
| 2013-12-18 16:14 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2022-01-12 13:15 | Martijn Tonies | Project | Database Workbench v5 => ADS LogManager |
| 2022-01-12 13:15 | Martijn Tonies | Category | Firebird Module => @1@ |
| 2022-01-12 13:17 | Martijn Tonies | Project | ADS LogManager => Database Workbench v6 |
| 2022-01-12 13:19 | Martijn Tonies | Category | @1@ => Firebird Module |
