Search Postgresql Archives

Creating a column interger with default to not null

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I am confused with what this is telling me.
I have a table and I am trying to add a new column with constraint not null.


What am I missing?
Chris


pgdb001=> alter table schema.table add COLUMN column_name integer not null;
ERROR:  column "column_name" contains null values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux