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