Thanks for the input Tom 1) SHOW search_path; -- produces the following and the function was in the public schema (and both created by the same user)
search_path ----------------- "$user", public 2) I was calling it with: SELECT getSessDbKey (jSessionId, jUser, 'functionName'::text, vSessDbKey, vSessRet, vGetSessDbKeyMess); I just tried to user CALL and the HINT was to use SELECT Mark On Sun, Oct 25, 2026 at 1:00 PM Tom Lane <[email protected]> wrote: > Mark <[email protected]> writes: > > I am getting the following error which has been driving me crazy: > > ERROR: function getsessdbkey(text, text, text, bigint, customType, text) > > does not exist > > (1) search_path problem, perhaps? > (2) are you using a CALL statement to call it? > > regards, tom lane >
