Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable

2022-05-08 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> « >> Note that ASSERT is meant for detecting program bugs, not for reporting >> ordinary error conditions. Use the RAISE statement, described above, for >> that. >> » >> >> But it takes quite a stretch of the imagination t

Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable

2022-05-08 Thread David G. Johnston
On Sunday, May 8, 2022, Bryn Llewellyn wrote: > > « > Note that ASSERT is meant for detecting program bugs, not for reporting > ordinary error conditions. Use the RAISE statement, described above, > for that. > » > > But it takes quite a stretch of the imagination to infer that this means > that

The P0004 assert_failure exception assert_failure exception seems to be unhandleable

2022-05-08 Thread Bryn Llewellyn
I just stumbled on the fact that the "assert_failure" exception seems to be unhandleable. My test is at the end. Is this intended? I looked at the section: « 43.9.2. Checking Assertions https://www.postgresql.org/docs/current/plpgsql-errors-and-messages.html#PLPGSQL-STATEMENTS-ASSERT » It says