pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: qtds_126 <qtds_126@126.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: The keyword in the procedure's error message is "function", which should be "procedure"
Date: Wed, 21 Sep 2022 17:05:13 +0800 (GMT+08:00)
Message-ID: <29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com> (raw)

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.

Attachments:

B242659D-884C-454D-928E-426E38915C11.png (image/png, 17.6K) download view image

view thread (4+ messages)  latest in thread

Message-ID: <29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com>
Permalink:  ../29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com/
Also on:    postgresql.org/message-id/29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: qtds_126@126.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: The keyword in the procedure's error message is "function", which should be "procedure"
  In-Reply-To: <29ea5666.6ce8.1835f4b4992.Coremail.qtds_126@126.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox