Re: NOTICE vs WARNING

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Peter Eisentraut" <peter_e@gmx.net>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "PostgreSQL Development" <pgsql-hackers@postgresql.org>
Date: 2003-09-03T01:46:01Z
Lists: pgsql-hackers
> 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.

Chris