![Alter column, set as NOT NULL and Set Default value, PostgreSQL. · Issue #12077 · yiisoft/yii2 · GitHub Alter column, set as NOT NULL and Set Default value, PostgreSQL. · Issue #12077 · yiisoft/yii2 · GitHub](https://user-images.githubusercontent.com/7445875/37251434-d25644de-254a-11e8-8143-14d5a1cbaf23.png)
Alter column, set as NOT NULL and Set Default value, PostgreSQL. · Issue #12077 · yiisoft/yii2 · GitHub
![java - org.postgresql.util.PSQLException: ERROR: null value in column "category_id" violates not-null constraint - Stack Overflow java - org.postgresql.util.PSQLException: ERROR: null value in column "category_id" violates not-null constraint - Stack Overflow](https://i.stack.imgur.com/r1Wmh.jpg)
java - org.postgresql.util.PSQLException: ERROR: null value in column "category_id" violates not-null constraint - Stack Overflow
![sql server - Why does ALTER COLUMN to NOT NULL cause massive log file growth? - Database Administrators Stack Exchange sql server - Why does ALTER COLUMN to NOT NULL cause massive log file growth? - Database Administrators Stack Exchange](https://i.stack.imgur.com/nxDt9.png)
sql server - Why does ALTER COLUMN to NOT NULL cause massive log file growth? - Database Administrators Stack Exchange
![Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking | by Christophe Escobar | Doctolib | Medium Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking | by Christophe Escobar | Doctolib | Medium](https://miro.medium.com/v2/resize:fit:1400/1*4ZqsvV3Ghz1X_pEBYUdHaw.png)