adding not null constraint to existing table - Mailing list pgsql-general

From Alex Howansky
Subject adding not null constraint to existing table
Date
Msg-id Pine.LNX.4.30.0102021120210.9610-100000@net-srv-0001.bvrd.com
Whole thread Raw
Responses Re: adding not null constraint to existing table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
What's the simplest way to add a not null constraint to a field in an existing
table? It doesn't seem that alter table supports it -- that I'll have to create
a new table and copy into it. Is that correct? TIA,

--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Left Join Complex Query
Next
From: Stephan Szabo
Date:
Subject: Re: plpgsql always returning null..