View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001269 | Database Workbench v6 | Firebird Module | public | 2015-08-04 11:17 | 2022-01-12 13:12 |
| Reporter | Kim Sandell | Assigned To | |||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Platform | win10 | OS | win10 | OS Version | win10 |
| Product Version | 5.1.4 | ||||
| Summary | 0001269: Duplicating a TABLE - the new table that is edited does not have trigger names changed | ||||
| Description | The AutoIncrement trigger name and generator name inside does not have the new tables name, and causes a "Trigger already exists" error when saving the duplicated table. | ||||
| Steps To Reproduce | Steps: 1) Create a table 2) Add one ID field, as BigInt NOT NULL PRIMARY KEY, and autocreate trigger 3) Save 4) Duplicate this table (right click -> duplicate) 5) Enter new name 6) OK 7) Save new table (this will fail) | ||||
| Tags | No tags attached. | ||||
|
|
Workaround is to DUPLICATE table with Actions: (*) Just Duplicate Object This will only create the table and fields, but omits the AutoIncrement trigger. Then open the table and right-click ID column and add the Autoincrement. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-08-04 11:17 | Kim Sandell | New Issue | |
| 2015-08-04 11:21 | Kim Sandell | Note Added: 0000383 | |
| 2015-08-27 08:53 | Martijn Tonies | Status | new => acknowledged |
| 2022-01-12 13:12 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
