Tag

On Postgres 11 and later a nullable column with a default is a metadata-only change. Adding NOT NULL afterwards is the part that needs care.

Copying rows with explicit ids leaves the identity sequence behind, so the next insert collides with an existing row.