| From: | Mark <nvpostgres(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Debugging --- ERROR: function does not exist |
| Date: | 2026-10-25 13:26:18 |
| Message-ID: | CAAm-KOvOnCw8YEMKh8NLvJoHzm2R3A3_xW=9ecf4+mdMV=xPEg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mark <nvpostgres(at)gmail(dot)com> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dustin Sanza | 2026-10-25 14:04:08 | Re: PostgreSQL 17: protecting role attributes between verification and COMMIT |
| Previous Message | 이정호 | 2026-10-25 13:17:16 | Request for Official Technical Clarification on PostgreSQL statement_timeout Error |