Postgres Pro
Downloads
Home   >   mailing lists

ALTER TABLE Column NOT NULL? - Mailing list pgsql-general

From Gregory Wood
Subject ALTER TABLE Column NOT NULL?
Date
Msg-id 000701c1a5d8$015bffd0$7889ffcc@comstock.com
Whole thread Raw
Responses Re: ALTER TABLE Column NOT NULL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ALTER TABLE Column NOT NULL?  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Arguile"
Date:
Subject: Re: grant the right to select only certain rows?
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE Column NOT NULL?