-
Notifications
You must be signed in to change notification settings - Fork 796
Closed
Description
Test case:
- Drill down to any table (with existing rows) that has an auto-generated PK (e.g., determined by a Sequence)
- Right-click on table, and select "View/Edit Data" | "All rows"
- Select any row in the results list
- Click the "Copy" icon (above the results list)
- Click the "Paste" icon (above the results list)
- Find the newly-pasted row (see bug Bug (usability) with Copy-and-Paste of table rows #5921)
Note, that the copied row's PK has been included in the newly-pasted row.
So the first thing you have to do, EVERY TIME you copy and paste a row, is select the PK in the new row, and delete it. Otherwise, when you click "Save Data Changes" you'll get a small error notification that the row could be saved because the PK is already in use.
Could you please change the paste behaviour to blank out the PK, since it always needs to be blanked out, anyway?