Christopher Kings-Lynne wrote:
> > In fact, I like the criterion that a warning should be raised rather than
> > a notice if the effect of the command deviates from what the command
> > actually says. That puts the messages for serials, primary keys, drop
> > cascades clearly into notices, messages about missing, implicitly added,
> > or changed syntax clauses into warnings.
> >
> > I don't think the dump reload scenario is particularly important. After
> > all, psql or pg_restore don't act differently upon notice or warning, it's
> > just something that the user reads.
>
> WARNINGs don't cause transaction rollback, right? Cos if they did, changing
> NOTICEs to WARNINGs would cause pain.
No, only ERROR does transaction rollback.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073