How to alter new not null column in Postgresql?
postgresql, sql, sql-null
Solution
To avoid your error, two solutions come at once:
BEGIN;
alter table poll_management.DASHLETS add column name varchar(255);
update poll_management.DASHLETS as dashlet set name = report.name
from poll_management.REPORTS as report;
--mind I removed where, cos you need to update ALL rows to have some avlue
alter table poll_management.DASHLETS alter column "name" set not null;
END;
and the other:
alter table poll_management.DASHLETS add column name varchar(255) NOT NULL default 'not set';
Problem
I have a table that I want to add new `not null varchar(255)` column My query is: ``` alter table poll_management.DASHLETS add column name varchar(255) not null; update poll_management.DASHLETS as dashlet set name = report.name from poll_management.REPORTS as report WHERE dashlet.id = report.reportdashletid ``` But I have an error: ``` ERROR: column "name" contains null values ********** Error ********** ERROR: column "name" contains null values SQL state: 23502 ```