| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Garo Hussenjian <garo(at)xapnet(dot)com> |
| Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Alter table syntax |
| Date: | 2002-10-23 13:39:00 |
| Message-ID: | 20021023133900.GA2294@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 22, 2002 at 11:38:33PM -0700, Garo Hussenjian wrote:
> Hello,
>
> Can anyone remind me how to make a column 'not null' after it is created?
ALTER TABLE ... ADD NOT NULL
But I think this is a 7.3 addition (i.e. not released yet).
If you don't have that, you can try looking up it's pg_attribute tuple
(it was shown here in the last week how to do so, AFAIR) and set to true
its attnotnull.
Be warned that incorrectly modifying system catalogs can lead to massive
data loss! Are you scared already? If so, take all needed precautions
and go ahead. If you don't, start imagining people yelling at you
because of a lost database and start again.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La espina, desde que nace, ya pincha" (Proverbio africano)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Prentzas | 2002-10-23 15:00:06 | Views + Criteria |
| Previous Message | Martijn van Oosterhout | 2002-10-23 12:22:49 | Re: Online backup |