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