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/