Since Pg12, even adding a column with a default doesn't lock the table anymore - that only happens if you later change or remove the default