On Apr 24, 2008, at 10:11 AM, Kaloyan Iliev wrote:
regbgrgr=# ALTER TABLE test ADD COLUMN not_null INT NOT NULL ;
ERROR: column "id" contains null values
==========================================EXAMPLE2====================
==================
Example2:
In this case the postgress fill the NOT NULL column ID from the
sequence.
What sequence? You never told it you wanted one. A PRIMARY KEY
doesn't automatically add a sequence nor does a NOT NULL constraint,
the serial type does that but you defined the column as type int, not
as type serial.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4810d219927662597012045!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
