| From: | <mallah(at)trade-india(dot)com> |
|---|---|
| To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <mallah(at)trade-india(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE does not raises WARNING/ERROR |
| Date: | 2003-03-22 17:49:59 |
| Message-ID: | 1084.219.65.230.11.1048355399.squirrel@mail.trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
oops sorry!
i too feel the same.
> 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
>
>
> ---------------------------(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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mallah | 2003-03-22 18:30:35 | Re: newline character in SQL |
| Previous Message | mallah | 2003-03-22 17:47:42 | Re: SQL help for efficient time handling.. |