Re: The keyword in the procedure's error message is "function", which should be "procedure"

I've submitted a patch to resolve this issue, waiting for reviews.

Thanks.

On Wed, Sep 21, 2022 at 7:13 PM qtds_126 <qtds_126(at)126(dot)com> wrote:

> *Bug Report*
>
> When an existing procedure is created in the database, an error message is
> prompted for an existing procedure.
> But the error message says "function" type.
>
> *PostgreSQL version*
> 11~15
> *Test SQL*
>
> create procedure proc_insert_t_pg_varchar(id int, v varchar)
> language plpgsql
> as $$
> declare
> iid int;
> vv varchar(5);
> begin
> iid = id;
> vv = v;
> insert into t_pg_varchar values(iid, vv);
> end;
> $$;
>
> *Test result*
>
> *Expected behavior*
>
> When an error occurs in procedure, the keyword is changed from "function"
> to "procedure".
>
>
> Thanks.
>

--
Regards
Junwang Zhao