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

Поиск
Список
Период
Сортировка
От Junwang Zhao
Тема Re: The keyword in the procedure's error message is "function", which should be "procedure"
Дата
Msg-id CAEG8a3LW9mUqNRFN3s1kDA_vmZNd34wg2yoacRq9kT5XF3sXVQ@mail.gmail.com
обсуждение исходный текст
Ответ на The keyword in the procedure's error message is "function", which should be "procedure"  (qtds_126 <qtds_126@126.com>)
Список pgsql-bugs
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@126.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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robins Tharakan
Дата:
Сообщение: Re: PANIC in heap_delete during ALTER TABLE
Следующее
От: Junwang Zhao
Дата:
Сообщение: Re: The keyword in the procedure's error message is "function", which should be "procedure"