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

From: qtds_126 <qtds_126(at)126(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: The keyword in the procedure's error message is "function", which should be "procedure"
Date: 2022-09-21 09:05:13
Message-ID: 29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robins Tharakan 2022-09-21 11:18:24 Re: PANIC in heap_delete during ALTER TABLE
Previous Message Michael Paquier 2022-09-21 05:46:38 Re: PANIC in heap_delete during ALTER TABLE