Re: Why doesn't `RAISE EXCEPTION` provide error context?

The OP on this thread has introduced a potential compromise.  Keep the current printing behavior for RAISE but the construction of the error itself should contain all of the relevant detail so that the caller can get to the suppressed information via, in this instance, GET STACKED DIAGNOSTICS inside an exception handler - a situation where the error is in context but has not yet been printed.

Giving the function author the ability, via a new using clause, to bypass the printing short-circuit is another feature to consider.

I haven't fully comprehended the design decisions and trade-offs but omitting data to facilitate printing doesn't sound like an appropriate solution - not that I have any clue how hard it would be separate the two aspects.  Likewise with adding in a short-circuit that is judgemental without providing some means to bypass it.  We are not talking about data integrity or performance here and while I'll admit reducing verbosity is a valid goal mis-use of a provided work-around mechanic is not that serious a transgression and one readily noticed and somewhat readily corrected.

David J.