pgsql: Improve error messages for CREATE OR REPLACE PROCEDURE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improve error messages for CREATE OR REPLACE PROCEDURE
Date: 2018-08-18 20:08:56
Message-ID: E1fr7Wq-0000qd-Ap@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve error messages for CREATE OR REPLACE PROCEDURE

Change the hint to recommend DROP PROCEDURE instead of FUNCTION. Also
make the error message when changing the return type more specific to
the case of procedures.

Reported-by: Jeremy Evans <code(at)jeremyevans(dot)net>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d83423db869900ffa2470826de5f8255d45ff9c6

Modified Files
--------------
src/backend/catalog/pg_proc.c | 31 +++++++++++++++++++++++++------
1 file changed, 25 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Noah Misch 2018-08-19 08:15:15 pgsql: MSVC: Remove any tmp_check directory before running a TAP test s
Previous Message Tom Lane 2018-08-18 18:02:40 pgsql: Doc: remove obsolete advice about manually inserting snprintf in