Re: Debugging --- ERROR: function does not exist

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
>

In response to

Responses

Browse pgsql-general by date

  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