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