DBeaver
Constraint between foreign key and primary key not working in Dbeaver #35333
-
DescriptionHi everyone, I'm having a problem with Dbeaver. I successfully created the foreign key constraint, I chose to update casecade and delete casecade , but when I rechecked it, it didn't work. Can you help me that why? DBeaver VersionDbeaver 24.1.5 Operating Systemwindow 10 Database and driverNo response Steps to reproduceNo response Additional contextNo response |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments
-
|
This is not a Dbeaver issue more like a question, you can ask questions like this in the discussion if you would like to: https://github.com/orgs/dbeaver/discussions Did you turn on the PRAGMA foreign_keys setting on your sqlite db? https://docs.sqlalchemy.org/en/13/dialects/sqlite.html#foreign-key-support |
Beta Was this translation helpful? Give feedback.
-
|
@TB-HunBoka Thanks so much! I finished. :) |
Beta Was this translation helpful? Give feedback.
-
|
Happy to help. |
Beta Was this translation helpful? Give feedback.
This is not a Dbeaver issue more like a question, you can ask questions like this in the discussion if you would like to: https://github.com/orgs/dbeaver/discussions
Did you turn on the PRAGMA foreign_keys setting on your sqlite db?
As far as I know it is not enabled by default and you need to enable it.
Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA foreign_keys command.
https://docs.sqlalchemy.org/en/13/dialects/sqlite.html#foreign-key-support