Re: I think this is a BUG?

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!

In response to

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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