Re: NOTICE vs WARNING - Mailing list pgsql-hackers

From Tom Lane
Subject Re: NOTICE vs WARNING
Date
Msg-id 11312.1061845468@sss.pgh.pa.us
Whole thread Raw
In response to NOTICE vs WARNING  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Can someone explain in succinct and general terms what the difference
> between a NOTICE and a WARNING is?  I'm currently examining the validity
> of notice and warning messages throughout the backend, but I find these
> categories to be applied inconsistently.

I'm sure they are :-(.  WARNING was invented much later than NOTICE, and
I don't believe anyone tried to come up with a hard-and-fast distinction,
much less go through the code line-by-line to apply it consistently to
existing NOTICEs.

I'd say that WARNING means "this is probably wrong, you'd better take
a close look" while NOTICE is something that's probably OK but we want
to tell the user what we're doing.  Dunno whether that's precise enough
though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12