Re: BUG #16405: Exception P0004 not caught in EXCEPTION WHEN OTHERS

Thanks for the reply Tom! Makes sense.

On Thu, Apr 30, 2020 at 12:04 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> > Excepted Behavior: P0004 exception is caught in EXCEPTION WHEN OTHERS,
> > function returns text 'Hit the Other exception block'.
> > Actual Behavior: P0004 exception is raised and remains uncaught.
>
> That's intentional, per the documentation [1]:
>
> The special condition name OTHERS matches every error type except
> QUERY_CANCELED and ASSERT_FAILURE. (It is possible, but often unwise,
> to trap those two error types by name.)
>
> regards, tom lane
>
> [1]
> https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>