Thread: removing "not null" modifier

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
REFERENCESstatus(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?  

thanks,

Robert Urban

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

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> O Robert Urban ������ ���� Mar 13, 2006 :
>> how can I get rid of the "not null" modifier on status_id?  

> ALTER TABLE event ALTER status_id DROP NOT NULL;

I don't think 7.2 has that.  Of course, there are many excellent reasons
why Robert needs to get himself off 7.2.2 ASAP.  Some of them can be
found here:
http://developer.postgresql.org/docs/postgres/release.html
        regards, tom lane