Re: removing "not null" modifier

O Robert Urban έγραψε στις Mar 13, 2006 :

> Hello,
> 
> let's say I have created a postgresql-7.2.2 db using the following cmds:
> 
>     CREATE TABLE status
>     (
>         id SERIAL NOT NULL PRIMARY KEY,
>         name VARCHAR(32)
>     );
> 
>     CREATE TABLE event
>     (
>         id SERIAL NOT NULL PRIMARY KEY,
>         description VARCHAR(32),
>         status_id  INTEGER NOT NULL REFERENCES status(id)
>     );
> 
> in psql I then see:
> 
> mydb=# \d event
>                                      Table "event"
>    Column    |         Type          |                    Modifiers                     
> -------------+-----------------------+--------------------------------------------------
>  id          | integer               | not null default nextval('"event_id_seq"'::text)
>  description | character varying(32) | 
>  status_id   | integer               | not null
> Primary key: event_pkey
> Triggers: RI_ConstraintTrigger_43210
> 
> 
> The question:
> 
> how can I get rid of the "not null" modifier on status_id?  

ALTER TABLE event ALTER status_id DROP NOT NULL;


> 
> thanks,
> 
> Robert Urban
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
-Achilleus