Re: skipping context for RAISE statements - maybe obsolete? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: skipping context for RAISE statements - maybe obsolete?
Date
Msg-id 19873.1355250557@sss.pgh.pa.us
Whole thread Raw
In response to skipping context for RAISE statements - maybe obsolete?  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: skipping context for RAISE statements - maybe obsolete?
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
>         /* if we are doing RAISE, don't report its location */
>         if (estate->err_text == raise_skip_msg)
>                 return;

> It is some what we want?

My recollection is that that special case was added because people
complained about the "noise" from location lines otherwise: there are
too many applications using RAISE to report user errors, for which a
traceback would just be useless noise.  I dug around in the archives a
bit but couldn't find the original discussion.  But I did find a fairly
recent complaint that it's still too noisy (rather than not noisy
enough):
http://archives.postgresql.org/pgsql-hackers/2011-10/msg00838.php

At the end of that thread we discussed adding a RAISE option to control
the behavior, but nothing's been done about it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: autovacuum truncate exclusive lock round two
Next
From: "Karl O. Pinc"
Date:
Subject: Re: Multiple --table options for other commands