removing "not null" modifier
От | Robert Urban |
---|---|
Тема | removing "not null" modifier |
Дата | |
Msg-id | 200603131307.k2DD73BB020477@noisy.spielwiese.de обсуждение исходный текст |
Ответы |
Re: removing "not null" modifier
|
Список | 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 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
В списке pgsql-sql по дате отправления: