Re: I get ERROR: column "table_name" does not exist

I made a gist with the error.
https://gist.github.com/floratmin/a4b404f0fd66b03a0428c07686b71410

On Fri, Jun 7, 2024 at 3:24 AM Erik Wienhold <ewie(at)ewie(dot)name> 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_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_object('table', table_name);
>
> But that's still guesswork without seeing the actual function definition
> with your edits.
>
> > On Wed, Jun 5, 2024 at 6:32 PM Erik Wienhold <ewie(at)ewie(dot)name> wrote:
> > >
> > > 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/issues/8#issuecomment-2147984520
> > >
> > > * Do you have a reproducer with those diagnostic items? The linked
> > > script does not use any of the items that you've mentioned.
> > >
> > > * Which Postgres version?
>
> --
> Erik