On Mon, Jul 29, 2002 at 12:32:53PM -0700, Patrick Nelson wrote:
> Tried the following:
>
> ALTER TABLE mss ADD COLUMN id int4 NOT NULL;
> ALTER TABLE mss ALTER COLUMN id SET DEFAULT nextval('mss_id_seq'::text);
>
> But it doesn't set the column modifier to NOT NULL. Why?
You should get an error in 7.2.x; it fails silently in 7.1. It's not
implemented yet. You can make it happen, however, by setting a
CHECK NOT NULL constraint on the column.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110