Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Verify FK being set to a PK column #4225

Open
pawelsalawa opened this issue Oct 2, 2021 · 0 comments
Open

Verify FK being set to a PK column #4225

pawelsalawa opened this issue Oct 2, 2021 · 0 comments
Labels
enhancement New feature or request
Milestone
3.5.0

Comments

@pawelsalawa
Copy link
Owner

Details

SQLite generally complaints about trying to point FK to a column that is not PK. It will complain only when user commits data for the FK column - which is late and the message is also confusing ("foreign key mismatch").

SQLiteStudio should verify if user is setting FK to a column that is not PK and warn user about what will probably happen because of that.
@pawelsalawa pawelsalawa added the enhancement New feature or request label Oct 2, 2021
@pawelsalawa pawelsalawa added this to the 3.4.0 milestone Oct 2, 2021
@pawelsalawa pawelsalawa modified the milestones: 3.4.0, 3.5.0 Oct 24, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
3.5.0
Development

No branches or pull requests
1 participant
@pawelsalawa