Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
> The argument could be made that what I've characterised as severe
> (which is, as I've said, not entirely clear-cut) could be deduced
> from SQLSTATE if we were to formalise the "can't happen errors are
> only allowed to use elog()" convention into a hard rule.
That doesn't seem necessary or desirable. The thing to do is to
somewhere define a list of what is "severe". It seems likely that
different shops may have different opinions on what constitutes a
"severe" problem, or may have more than a "severe"/"not severe"
dichotomy. So it would be best if it was configurable. To solve
the problem, we mostly seem to need something which can scan the
server log and take action based on SQLSTATE values. Since we can
already easily log those, this seems like territory for external
monitoring software.
I don't see anything for the community here other than to discuss
places where we might want to use a different SQLSTATE than we
currently do. Or possibly hooks in the logging process, so monitors
don't need to scan text.
-Kevin