sqlite3 “foreign key constraint failed”

I’ve set up two tables:

CREATE TABLE A
(
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT
 );

CREATE TABLE B
(
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    id2 INTEGER,
    book TEXT,
    FOREIGN KEY(id2) REFERENCES A(id)
);

After I insert data into A, it looks like this:

1    John

2    Amy

3    Peter

After I insert data into B, it looks like this:

1     1     Lord of the Rings

2     1     Catch 22

3     2     Sum of All Fears

4     3     Hunt for Red October

I then execute the following statement:

delete from a where id=1;

I get the following: "Error: foreign key constraint failed"

I then restart sqlite3 and try again but this time I enter this first:

PRAGMA foreign_keys = 1;

it still doesn’t work……

Related Posts:

  1. How can I add the sqlite3 module to Python?
  2. How do I unlock a SQLite database?
  3. How to get a list of column names on Sqlite3 database?
  4. Creating stored procedure and SQLite?
  5. SQLITE, Create a temp table then select from it
  6. File extension .DB – What kind of database is it exactly?
  7. How to establish ssh key pair when “Host key verification failed”
  8. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  9. How to use SQLite in Visual Studio 2017?
  10. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  11. MySQL Cannot Add Foreign Key Constraint
  12. Where does Chrome keep the SQLite Database file it writes things like stored passwords to?
  13. Can a foreign key be NULL and/or duplicate?
  14. MySQL DROP all tables, ignoring foreign keys
  15. How to open .SQLite files
  16. SQLite – UPSERT *not* INSERT or REPLACE
  17. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  18. SQLiteDatabase.query method
  19. When to use “ON UPDATE CASCADE”
  20. Django – no such table exception
  21. Exit a SQLite 3 database
  22. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  23. Sqlite3, OperationalError: unable to open database file
  24. Django – no such table exception
  25. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  26. “Insert if not exists” statement in SQLite
  27. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  28. Error: C2228: left of ” must have class/struct/union
  29. What is difference between SQLite and SQL
  30. java.lang.ClassNotFoundException: org.sqlite.JDBC error in Sample.java program from xerial
  31. Convert MySQL to SQlite [closed]
  32. sqlite3.OperationalError: unable to open database file
  33. entity object cannot be referenced by multiple instances of IEntityChangeTracker. while adding related objects to entity in Entity Framework 4.1
  34. OperationalError: database is locked
  35. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  36. MySQL Error 1215: Cannot add foreign key constraint
  37. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  38. What is related_name used for?
  39. SQLite string contains other string query
  40. Is it fine to have foreign key as primary key?
  41. Why do I get sqlite error, “unable to open database file”?

Leave a Comment

tech