[grebc]

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]

You create a nullable column and then change it to not null. Which wasn't possible in SQLite until recently.

[grebc]

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.