这是indexloc提供的服务,不要输入任何密码
Skip to content

Clear PK on Copy-and-Paste of table rows #5922

@usernamesareaholdoverfromthe90s

Description

Test case:

  1. Drill down to any table (with existing rows) that has an auto-generated PK (e.g., determined by a Sequence)
  2. Right-click on table, and select "View/Edit Data" | "All rows"
  3. Select any row in the results list
  4. Click the "Copy" icon (above the results list)
  5. Click the "Paste" icon (above the results list)
  6. 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?

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions