Received: from uni-box.nice.be (IDENT:0@nice.be [195.144.66.92]) by hub.org (8.10.1/8.10.1) with ESMTP id e6K7jxh97490 for ; Thu, 20 Jul 2000 03:45:59 -0400 (EDT) Received: from nice.be ; Thu, 20 Jul 2000 09:45:49 +0200 Message-ID: <3976B081.3AC847A4@nice.be> Date: Thu, 20 Jul 2000 09:55:45 +0200 From: Wim Ceulemans X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: Carolyn Lu Wong CC: "pgsql-sql@postgresql.org" Subject: Re: from not null field to nullable field? References: <39769880.85E7D796@kss.net.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/191 Carolyn Lu Wong wrote: > > I have a field in a table that has been defined 'not null'. Is it > possible to remove this constraint? I don't see this option under 'alter > table'. update pg_attribute set attnotnull = 'f' where oid = oidofnotnullcolumn; vacuum analyze; Regards Wim