Re:SQLite Release 3.25.0 adds support for window functions
by silvestrov on Wednesday August 15, 2018 @05:55AM
(#17764814)
That’s not enough because it ignores all foreign key constraints.
[ Parent
| on HN ]
Re:SQLite Release 3.25.0 adds support for window functions
by ifdefdebug on Wednesday August 15, 2018 @07:37AM
(#17765258)
Lock db exclusively, disable foreign key checking, rebuild and replace table, reconfigure foreign keys (they are gone after delete and rename), and everything should be fine.