Thread: ALTER TABLE does not raises WARNING/ERROR
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.
On Sat, 22 Mar 2003, Rajesh Kumar Mallah wrote: > If a feild is already NOT NULL > setting it not null with ALTER command > does not issues any warning. I can't really see much point in issuing a warning for this case.
Rajesh Kumar Mallah <mallah@trade-india.com> 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
oops sorry! i too feel the same. > Rajesh Kumar Mallah <mallah@trade-india.com> 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/