On Thursday, September 9, 2021, R. Schottland (Lowell) <
rschottland@lowell.edu> wrote:
ERROR: function kepler_start_3(double precision, double precision) does not exist
LINE 1: SELECT kepler_start_3(cast(ecc AS DOUBLE PRECISION), CAST(mn...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
While the hint in the error message says “No function matches the given name and argument types.”, we confirmed that the called function and two other functions called by it are present in the public schema are immutable functions, and after extensive type-checking was performed, we can confirm that all argument types are consistent with those functions.
You are assuming that the public schema is in the search_path but for added security the dump file sets things up so it is not. Your functions need to be modified, either by adding a set search_path clause to the function metadata or by schema qualifying function calls within the body of the function.
David J.
