Re: Identifying function-lookup failures due to argument name mismatches
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-08-24T18:47:12Z
Lists: pgsql-hackers
Attachments
- v4-0001-Provide-more-specific-error-hints-for-function-lo.patch (text/x-diff) patch v4-0001
- v4-0002-Change-the-wording-of-our-traditional-function-no.patch (text/x-diff) patch v4-0002
- v4-0003-Improve-the-messages-for-operator-not-found-too.patch (text/x-diff) patch v4-0003
- v4-0004-Mop-up-a-few-other-error-message-style-violations.patch (text/x-diff) patch v4-0004
Here is a v4 with some additional bike-shedding on the error texts. In particular, I decided that it was worth expending an additional flag bit so that we could reliably distinguish "There is no function of that name" from "A function of that name exists, but it is not in the search_path". (Since FuncnameGetCandidates is already searching the entire set of functions matching the given name, it doesn't take any extra work to know that there's a match outside the search path.) I rephrased a couple of the other messages too, but without any substantive logic change. regards, tom lane
Commits
-
Provide more-specific error details/hints for function lookup failures.
- 83a56419457e 19 (unreleased) landed