ALTER TABLE Column NOT NULL?

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: ALTER TABLE Column NOT NULL?
Date: 2002-01-25 19:39:28
Message-ID: 000701c1a5d8$015bffd0$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way to add a NOT NULL constraint to a new field in a table,
*without* having to dump and restore the entire thing? I suppose I could add
a trigger (or modify an existing one), but that feels so... wrong.

Greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-25 19:52:35 Re: ALTER TABLE Column NOT NULL?
Previous Message Elein 2002-01-25 19:08:02 Re: Yet another optimizer index choosing questions