Changes between Initial Version and Version 1 of Ticket #28849
- Timestamp:
- Nov 26, 2017, 9:42:53 PM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #28849
- Property Has patch set
- Property Patch needs improvement set
-
Ticket #28849 – Description
initial v1 12 12 sqlite> ALTER TABLE foo RENAME TO renamed; 13 13 sqlite> .schema bar 14 CREATE TABLE bar ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "foo_id" integer NOT NULL REFERENCES "foo" ("id") DEFERRABLE INITIALLY DEFERRED); #It still points to "foo"14 CREATE TABLE bar ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "foo_id" integer NOT NULL REFERENCES "foo" ("id") DEFERRABLE INITIALLY DEFERRED); -- It still points to "foo" 15 15 sqlite> INSERT INTO bar (foo_id) VALUES (999); 16 sqlite> PRAGMA foreign_keys = ON; #From Django 2.0+16 sqlite> PRAGMA foreign_keys = ON; -- From Django 2.0+ 17 17 sqlite> INSERT INTO bar (foo_id) VALUES (999); 18 18 Error: no such table: main.foo