Re: NOTICE vs WARNING

Peter Eisentraut wrote:
> Christopher Kings-Lynne writes:
>
> > Surely a WARNING is a problem that you should probably fix?
>
> How are "should" and "probably" defined?
>
> > Or at least pay attention to.
>
> If it were in fact the characteristic of a NOTICE that you need not pay
> attention to them, why do we have them?
>
> > My thought is that you could turn of NOTICES and not worry.
>
> Well, there are plenty of NOTICE instances that carry a definite need to
> worry, such as identifier truncation, implicitly added FROM items,
> implicit changes to types specified as "opaque", unsupported and ignored
> syntax clauses.
>
> I have a slight feeling that these two categories cannot usefully be
> distinguished, but I'm interested to hear other opinions.

The creation of a sequence during SERIAL creation is clearly a notice:

test=> create table x(y serial);
NOTICE: CREATE TABLE will create implicit sequence "x_y_seq" for SERIAL
column "x.y"
CREATE TABLE

That is what I used as a guide I think --- notices were things we want
to tell you about, but you shouldn't be concerned about it. (Hey, I did
it without using "probably").

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073