I made a gist with the error.
https://gist.github.com/floratmin/a4b404f0fd66b03a0428c07686b71410
On Fri, Jun 7, 2024 at 3:24 AM Erik Wienhold wrote:
>
> On 2024-06-06 15:08 +0200, Florian Koch wrote:
> > This is the working example, when I replace any of e.g.
> > 'PG_EXCEPTION_HINT' with 'TABLE_N
On 2024-06-07 14:24 +0200, Florian Koch wrote:
> I made a gist with the error.
> https://gist.github.com/floratmin/a4b404f0fd66b03a0428c07686b71410
The problem is the semicolon after PG_DATATYPE_NAME, causing the
TABLE_NAME line to be a separate statement:
>exception_datatype := PG_DATATYPE_N
This is the working example, when I replace any of e.g.
'PG_EXCEPTION_HINT' with 'TABLE_NAME'. Then the function throws. I am
using postgres 16.1.
On Wed, Jun 5, 2024 at 6:32 PM Erik Wienhold wrote:
>
> On 2024-06-04 21:50 +0200, PG Doc comments form wrote:
> > When using GET STACKED DIAGNOSTICS
On 2024-06-06 15:08 +0200, Florian Koch wrote:
> This is the working example, when I replace any of e.g.
> 'PG_EXCEPTION_HINT' with 'TABLE_NAME'. Then the function throws. I am
> using postgres 16.1.
Perhaps you did not declare variable table_name and run something like:
RETURN jsonb_build_ob
On 2024-06-04 21:50 +0200, PG Doc comments form wrote:
> When using GET STACKED DIAGNOSTICS in PL/pgSQL accessing TABLE_NAME,
> COLUMN_NAME, CONSTRAINT_NAME or SCHEMA_NAME throws an error.
>
> The function "shared.test_raise_exception":
> https://github.com/rin-nas/postgresql-patterns-library/issu
