| From: | marco ghidinelli <marcogh(at)linux(dot)it> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | cannot add "not null" to an existing table |
| Date: | 2002-10-21 16:09:10 |
| Message-ID: | 20021021160909.GA8352@ufficio.chiocciolina.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hello,
i can't be able to add a constraint to a table.
example:
alter table mytable add primary key (id);
-- i get the error: Existing attribute "id" cannot be a PRIMARY KEY because
-- it is not marked NOT NULL
--
-- but at this point i cannot be able to add the constraint not null to the
-- column id.
--
-- i tried:
alter table mytable alter column id set not null;
-- ERROR: parser: parse error at or near "not"
alter table mytable set not null (id);
-- ERROR: parser: parse error at or near "set"
alter table mytable add not null (id);
-- ERROR: parser: parse error at or near "not"
----------------------------------------
note that i must alter an existing table, or copying and modifying an
existing table.
postgresql 7.2.3 - debian package.
postgresql 7.2.2 - debian package.
any idea?
--
BOFH excuse #321:
Scheduled global CPU outage
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2002-10-21 16:11:35 | Numerous postmaster processes after upgrading to 7.2.3 |
| Previous Message | Jeffrey Bohmer | 2002-10-21 16:08:52 | Re: Buffers and MacOS X |