“Duplicate Record” option fails because of PK/unique constraints #4089
driftingprogrammer
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Problem
The "Duplicate Row" option in the Browse Data tab almost always fails due to primary key or unique constraints. In practice, most SQLite tables have a PK, so the feature is unusable.
Expected behavior
Either:
Actual behavior
DB Browser executes the duplicate immediately, causing a constraint violation. The option is prominently available but misleading.
Suggested resolution
Treat this as a usability bug:
Notes
Other tools (e.g. DBeaver) allow duplication + editing before commit, so users expect similar behavior. As it stands, the option is confusing and feels broken.
Beta Was this translation helpful? Give feedback.
All reactions