X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0A70A9DCC05 for ; Mon, 13 Mar 2006 11:47:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72843-06 for ; Mon, 13 Mar 2006 11:47:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 999C59DC819 for ; Mon, 13 Mar 2006 11:47:28 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k2DFlNkc007582; Mon, 13 Mar 2006 10:47:23 -0500 (EST) To: Achilleus Mantzios cc: Robert Urban , pgsql-sql@postgresql.org Subject: Re: removing "not null" modifier In-reply-to: References: Comments: In-reply-to Achilleus Mantzios message dated "Mon, 13 Mar 2006 17:04:03 +0200" Date: Mon, 13 Mar 2006 10:47:23 -0500 Message-ID: <7581.1142264843@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200603/194 X-Sequence-Number: 24540 Achilleus Mantzios writes: > O Robert Urban έγραψε στις Mar 13, 2006 : >> how can I get rid of the "not null" modifier on status_id? > ALTER TABLE event ALTER status_id DROP NOT NULL; I don't think 7.2 has that. Of course, there are many excellent reasons why Robert needs to get himself off 7.2.2 ASAP. Some of them can be found here: http://developer.postgresql.org/docs/postgres/release.html regards, tom lane