Re: ALTER TABLE does not raises WARNING/ERROR

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ALTER TABLE does not raises WARNING/ERROR
Date: 2003-03-22 16:10:59
Message-ID: 683.1048349459@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rajesh Kumar Mallah <mallah(at)trade-india(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-03-22 16:17:19 Re: SQL help for efficient time handling..
Previous Message Stephan Szabo 2003-03-22 16:09:43 Re: ALTER TABLE does not raises WARNING/ERROR