Postgres Pro
Downloads
Home   >   mailing lists

Creating a column interger with default to not null - Mailing list pgsql-general

From Chris Barnes
Subject Creating a column interger with default to not null
Date
Msg-id BLU149-W22F7F504C6BBE98ADFA3CDD4620@phx.gbl
Whole thread Raw
Responses Re: Creating a column interger with default to not null  (Thom Brown <thom@linux.com>)
Re: Creating a column interger with default to not null  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: "Bret S. Lambert"
Date:
Subject: Re: Libpq memory leak
Next
From: "Wang, Mary Y"
Date:
Subject: Trade Study on Oracle vs. PostgreSQL