Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B93BD9FC059 for ; Thu, 18 Oct 2007 20:20:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 84659-07 for ; Thu, 18 Oct 2007 20:20:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtiwmhc13.worldnet.att.net (mtiwmhc13.worldnet.att.net [204.127.131.117]) by postgresql.org (Postfix) with ESMTP id BBFCB9FC046 for ; Thu, 18 Oct 2007 20:20:46 -0300 (ADT) Received: from [192.168.1.104] (h220.13.17.98.ip.alltel.net[98.17.13.220]) by worldnet.att.net (mtiwmhc13) with ESMTP id <20071018232045113005plsre>; Thu, 18 Oct 2007 23:20:45 +0000 Message-ID: <4717EA47.2080701@att.net> Date: Thu, 18 Oct 2007 19:20:39 -0400 From: Alex Kloss User-Agent: Thunderbird 2.0.0.5 (X11/20070727) MIME-Version: 1.0 To: yogesh , pgsql-admin@postgresql.org Subject: Re: Drop Not Null References: <1192687310.749557.227290@q5g2000prf.googlegroups.com> In-Reply-To: <1192687310.749557.227290@q5g2000prf.googlegroups.com> X-Enigmail-Version: 0.95.3 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig2F61571B130ECB73A0A7CF51" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/184 X-Sequence-Number: 27098 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2F61571B130ECB73A0A7CF51 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable yogesh wrote: > Hello Frnds, > What is the Command to drop the Not Null Constraint from a Column > of the Table.....Please reply asap............. > > Regards, > Yogesh Arora. > > > ---------------------------(end of broadcast)--------------------------= - > TIP 2: Don't 'kill -9' the postmaster > > =20 ALTER TABLE table ALTER COLUMN column DROP NOT NULL See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311= for more information about dropping constraints. Alex Kloss --------------enig2F61571B130ECB73A0A7CF51 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFHF+pMLGN3BhEHOicRAgcgAJ9eTiY68fF3JqexYTbEts906//JkACeNTDd GJlCFX4iqIjHu57HcZgw7Go= =JMwp -----END PGP SIGNATURE----- --------------enig2F61571B130ECB73A0A7CF51--