4 ms·

How do you migrate in place data that doesn’t convert between types while maintaining a strict condition like NOT NULL? This is again a scenario I’ve never run

by grebc 2mo ago

How do you migrate in place data that doesn’t convert between types while maintaining a strict condition like NOT NULL? This is again a scenario I’ve never run into 20ish years of SQL.

stanac 2mo ago
You create a nullable column and then change it to not null. Which wasn't possible in SQLite until recently.
- grebc 2mo ago
  I’m not sure what your original point is pointing out. Some data doesn’t convert is what I’m pointing out regardless of Postgres or SQLite.
  - stanac 2mo ago
    Ah, my bad, first I was wrong about null/not null, and now I see what you mean.