X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C1D67474E4F for ; Sat, 22 Mar 2003 06:57:50 -0500 (EST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by postgresql.org (Postfix) with SMTP id 65F37474E44 for ; Sat, 22 Mar 2003 06:57:50 -0500 (EST) Received: (qmail 31109 invoked by uid 505); 22 Mar 2003 11:57:37 -0000 Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with qmail-scanner-1.15 (uvscan: v4.1.60/v4171. Clear:. Processed in 1.642741 secs); 22 Mar 2003 11:57:37 -0000 Received: from mail-relay.trade-india.com (HELO system67.trade-india-local.com) (203.196.129.235) by ns5.trade-india.com with SMTP; 22 Mar 2003 11:57:35 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: pgsql-sql@postgresql.org Subject: ALTER TABLE does not raises WARNING/ERROR Date: Sat, 22 Mar 2003 17:27:59 +0530 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200303221727.59506.mallah@trade-india.com> X-Spam-Status: No, hits=0.0 required=5.0 tests=USER_AGENT version=2.50-cvs X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50-cvs (1.172-2003-02-14-exp) X-Archive-Number: 200303/524 X-Sequence-Number: 12563 If a feild is already NOT NULL setting it not null with ALTER command does not issues any warning. regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.