Re: Importing data

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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110