View Issue Details

IDProjectCategoryView StatusLast Update
0001269Database Workbench v6Firebird Modulepublic2022-01-12 13:12
ReporterKim Sandell Assigned To 
PrioritylowSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Platformwin10OSwin10OS Versionwin10
Product Version5.1.4 
Summary0001269: Duplicating a TABLE - the new table that is edited does not have trigger names changed
DescriptionThe 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 ReproduceSteps:
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)
TagsNo tags attached.

Activities

Kim Sandell

2015-08-04 11:21

reporter   ~0000383

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.

Issue History

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