X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D023C476262 for ; Sat, 22 Mar 2003 12:49:20 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 51BDF475B47 for ; Sat, 22 Mar 2003 12:49:17 -0500 (EST) Received: (qmail 22529 invoked from network); 22 Mar 2003 17:50:27 -0000 Received: from ns1.trade-india.com (HELO www.trade-india.com) (66.234.10.14) by infocom-236-129-del.trade-india.com with SMTP; 22 Mar 2003 17:50:27 -0000 Received: (qmail 18564 invoked by uid 99); 22 Mar 2003 17:49:59 -0000 Received: from 219.65.230.11 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Sat, 22 Mar 2003 23:19:59 +0530 (IST) Message-ID: <1084.219.65.230.11.1048355399.squirrel@mail.trade-india.com> Date: Sat, 22 Mar 2003 23:19:59 +0530 (IST) Subject: Re: ALTER TABLE does not raises WARNING/ERROR From: To: In-Reply-To: <683.1048349459@sss.pgh.pa.us> References: <200303221727.59506.mallah@trade-india.com> <683.1048349459@sss.pgh.pa.us> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-17.5 required=5.0 tests=IN_REP_TO,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME, NO_REAL_NAME,QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES autolearn=ham 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/529 X-Sequence-Number: 12568 oops sorry! i too feel the same. > Rajesh Kumar Mallah writes: >> If a feild is already NOT NULL >> setting it not null with ALTER command >> does not issues any warning. > > Why should it? Updating a field to the same value it already has > doesn't ordinarily issue a warning in SQL ... > > regards, tom lane > > > ---------------------------(end of broadcast)--------------------------- = TIP 5: Have you > checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/