pgsql: Improve error messages for CREATE OR REPLACE PROCEDURE

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@jeremyevans.net>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/49c1a4da641d52effb403bf79798975975b725a9

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