SQLite Forum

table locked when dropping a temp table
Login
Ah yes, you are right, and that can be a bit of a drawback if most of the columns have NOT NULL constraints. But I think ON CONFLICT still beats the alternatives...