Re: The keyword in the procedure's error message is "function", which should be "procedure" - Mailing list pgsql-bugs

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.