Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE does not raises WARNING/ERROR - Mailing list pgsql-sql

From Tom Lane
Subject Re: ALTER TABLE does not raises WARNING/ERROR
Date
Msg-id 683.1048349459@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE does not raises WARNING/ERROR  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: ALTER TABLE does not raises WARNING/ERROR  (<mallah@trade-india.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: ALTER TABLE does not raises WARNING/ERROR
Next
From: Stephan Szabo
Date:
Subject: Re: SQL help for efficient time handling..