Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKzR8-00000001Enr-43vU for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 14:43:03 +0000 Received: from localhost ([127.0.0.1]:58552 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xKzR7-00000003DGu-0vue for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 14:43:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:41892) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKzR6-00000003DGl-1aeN for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 14:43:00 +0000 Received: from fout-b7-smtp.messagingengine.com ([202.12.124.150]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKzR4-00000000ruB-1kfD for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 14:42:59 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id B8A161D000B9 for ; Sun, 25 Oct 2026 10:42:57 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Sun, 25 Oct 2026 10:42:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1792939377; x=1793025777; bh=vs7Eq8umdJp3wFCuf+W/dmLN1t2uH2byqXa+QvtfhBU=; b= Gyqj7FpP2qddQKxqdZ8Dt/UQYmcXhgpyHhUp3mx2O2ADnVB6WApjsadfMtFBreEj o6AOls5DikgJ+qyhJnAihPps2rIyRccPggGxi2DvvSP09h9ZRols4bNUXAU+hFQl y6OtivBZUjIi1pEGIXMfOrxVGNJnxFcBtFvw8s2f7LuQ3f9Yh+nwaYi3T1AtjlPB Ff1VP5gQT7/CDYu8WGxxzzig3Nv+E/A3NRt85isLPqm8YOuI4PdhmfT1tF3UPMtA TEKdgf62AyZwfcfo8B6v8QCZt9UCgMk3m7mtWIYc8vMVAxVqsHJBNsBLbyqggBQm EURuXe8BrhzsdvI9BwHt1A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1792939377; x= 1793025777; bh=vs7Eq8umdJp3wFCuf+W/dmLN1t2uH2byqXa+QvtfhBU=; b=O p6QO4YADjLAoLWruK3EGi5H2I24AVGMi2A5Va7dVX/5gcPElyF4Psodl5qG3jgxQ UqmWRg02HkqMrmmFL3k66e9kG89r5u5LshY4hKXztD1/GQ7LwNvr3GAg1nH8u8tH r7R01ts6VIkD+UDy0c3npQAfk9CaD2mgS4s2Fmb6Tu80sbU7/PwpvkiKogVxPhnW GTx3wcSeusMgm5RTWfMXSXuznoD60gOm5sUOMWfLbaKp6HGA7ayGBCiQpgJInWhJ h6H930iZRiyiMAVG12vkIVzSKOips74yeHbB/XFuLgoN7FVTJXaXw4tQrJBiyP4K HAXXnJFm+7kZdgOVgSEQw== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-07; repo=github.com/dkim2wg/interop; date=2026-10-18; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1792939377; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:TRxOoYzPFar+Web22rFx7kGHkJ0NYFrAbcvf4JK1nj4tFOV Bk+2u0no5TP6ZvnTtXFrrC+MD+gfoFjXAjSlKGmMMQMPEbWQlp/DH934vPa6zw+H dYd6N1yvsk8YTktVrm4fOmPDjF3AFlUxigVGKqAWtLZCmksqYcb3vOIDMaCcSO7r CRWjEhHJpWlodlBdxx7WEf8vGcTwlXUTa45cL5kRHQwxrABfgxvlTs875DIU4zSN hCFV/HU7vKaWMp1dI8pACcZk3uGLX53qHUbu4hPnJEDaOg8fdjRepT7IuNeXJdQb /TOsusqEKBXGBIumk3iVBaFLyaKXcL8DiSzFgNg==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-07; repo=github.com/dkim2wg/interop; date=2026-10-18; sw=lmtpprox; action=mi-m=1; hc=14; hn=cc,content-language,content-transfer-encoding,content-type, date,feedback-id,from,in-reply-to,message-id,mime-version, references,subject,to,user-agent; Message-Instance: m=1; h=sha256:5dduopPcrX1nNGttNKLPmBjbxfP1tUNPIuSQZSyMOpI=:R5pZGo+HvhuQd/psFXR7JTDoOhlAq7i3ErEz/rwvitI=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEDrFfiyqipmYGf3nn5+YpSYWCVxTXVrrfwvo66Wstm8Fj0kXrSS4fL4zfaX+JKNy 9J6fOjlR101/oqIi31BelZRT5hTqy/6nQZCsVWyZ+RlPnF4OI5onsvqegVCTdZA/lEmwPY z5f/PHUyfScV+7kFPkWm1vtnWoQAEww3zR4Us7qq4v/xckTDqHT3GV3tJoZcDeAEbPORIw HYPG14y8WmmetsgjfJSXZc6J2bGw948wr7G6UXFM1t6mXD4ioHdDfDFaIZLtTCH5X4jIRZ PPMWnG4HAbmOfqLcGfAHP6vTVngvpKxt26Fhmu657/MoMvk6c0K9xgLFxGB95bdNGKMUgc 2qmCDX//MKNfoIcLjM9eOfE7Zg0IPRqfhST1J7uE3Fd6fsExHxlTSzfm7Ns3/HJO8BORUQ /++vSRSKauUy+dGRCDJABHXxsD2jMLY05YFW55biEliS2yq68u+oH8FRkskzdm7MWetSR1 gRWP9zPg+nCBC+EShtndHku3Qhi7o+L9c2VPonkkUuauZH7XiEvjh0jLy7zMi7c8Ir4xLW M1u/fH6qwzvOSnC4XULMa+rZTcQZClgo0PfjQ5cdQkD8+9iKxj/breQ7Pq4k/82NvFLqNw 8pujKcudSBqBWhma3wERqOIeH2qf8AVPxIY1y9I1PqySIMFIKQiY0gPxndSw X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 25 Oct 2026 10:42:56 -0400 (EDT) Message-ID: Date: Sun, 25 Oct 2026 07:42:55 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Debugging --- ERROR: function does not exist To: Mark , Tom Lane Cc: pgsql-general@lists.postgresql.org References: <322082.1792933209@sss.pgh.pa.us> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/25/26 6:26 AM, Mark wrote: > 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: > SELECTgetSessDbKey (jSessionId, jUser, 'functionName'::text, vSessDbKey, > vSessRet, vGetSessDbKeyMess); This is not the same as: SELECT getSessDbKey (iSessionId => '1234'::text, iUser => 'cmd test'::text, iFunction => 'cmd test'::text); Note 3 parameters vs 6 in the 2). And from here: https://www.postgresql.org/docs/current/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS "To call a function with OUT parameters, omit the output parameter(s) in the function call: ..." > > 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 > wrote: > > Mark > 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 > -- Adrian Klaver adrian.klaver@aklaver.com