> > We could call it TIP or something like that. I think INFO is used
> > because it isn't a NOTICE or ERROR or something major. It is only INFO.
> > It is neutral information.
>
> That's what NOTICE is. NOTICE is only neutral information. NOTICE could
> go to the client by default, whereas if you want something in the server
> log you use LOG. I doubt an extra level is needed.
SQL92 has WARNING, would that be a suitable addition to NOTICE ?
INFO would not be added since it is like old NOTICE which would stay.
So, instead of introducing a lighter level we would introduce a
stronger level. (WARNING more important than NOTICE)
If we change, we might as well adopt some more SQL'ism.
e.g. string truncation is defined to return SUCCESS with WARNING.
I guess it would be a horror for existing client code though :-(
Andreas