Re: [PATCH] GET DIAGNOSTICS FUNCTION_NAME

On 12/31/17 11:57, Tom Lane wrote:
> 3. In connection with #2, I'm dubious that FUNCTION_NAME is le mot
> juste, because that would seem to imply that it is just the name,
> which it isn't. If we stick with the regprocedureout semantics
> I'd be inclined to propose FUNCTION_SIGNATURE.

The SQL standard has diagnostics items ROUTINE_CATALOG, ROUTINE_SCHEMA,
ROUTINE_NAME, which are used when there is an error invoking another
routine. Using notionally similar FUNCTION_* keys to mean my own
function seems pretty confusing (and also of questionable usefulness, as
you have commented).

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services