From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
---|---|
To: | kaloyan(at)digsys(dot)bg |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: I think this is a BUG? |
Date: | 2008-04-24 18:31:49 |
Message-ID: | 35895291-2ED7-459D-98D6-021203D9CB21@solfertje.student.utwente.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2008-04-24 19:01:14 | Re: How to modify ENUM datatypes? |
Previous Message | Chris Browne | 2008-04-24 18:28:16 | Re: Adding notes against fields |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-04-24 18:36:01 | Re: Proposed patch - psql wraps at window width |
Previous Message | Bruce Momjian | 2008-04-24 18:25:58 | Re: Proposed patch - psql wraps at window width |