From: | Robert Urban <urban(at)UNIX-Beratung(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | removing "not null" modifier |
Date: | 2006-03-13 13:07:03 |
Message-ID: | 200603131307.k2DD73BB020477@noisy.spielwiese.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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?
thanks,
Robert Urban
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Caune | 2006-03-13 14:21:41 | Re: Ask a PostgreSql question (about select ) |
Previous Message | Markus Schaber | 2006-03-13 12:34:23 | Re: Set generating functions and subqueries |