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 1xKzzU-00000001FC8-0E1C for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 15:18:32 +0000 Received: from localhost ([127.0.0.1]:54044 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xKzyU-000000000Wb-1Kmx for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 15:17:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:46078) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKzyT-000000000WT-1JGH for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 15:17:29 +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 1xKzyR-00000000sDV-0ht7 for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 15:17:28 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.stl.internal (Postfix) with ESMTP id 7508D1D000B1 for ; Sun, 25 Oct 2026 11:17:25 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Sun, 25 Oct 2026 11:17:25 -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=1792941445; x=1793027845; bh=8Z6isml+CFpEVs2mIaGwReU7TxdiukfgakFZfx+OwbA=; b= Cbi+fUuslP67OwVnRLCaCVh0EYwH3MJZerruVLctwvmG1PxYBOeajpRq8GKD5JK8 pkXrjRl9XY41GEtU2z9mzymulQ3StapXWaY+Ep2uZflJIeGslRF26o5u7nU2qaCR t+tmWJONIXLQKof0c0/RGXzoI4YEfP6VEw7m/Vo1MWqsVuyZlOXqxO1VmrtuM0Gr aqs/xOoxImutJNN0ITpHNMn4ehuZtCE44weUypjLLaeCbF+mzeykJMjg/iOi5KiP ipq7lF025Ds3sYOPggKaw43ZnvmLwDid83k9uJ5n5Zdpa2F7ufZvEnar4mUPhFyp +CT4HTCrhZYfACh/D5ITsA== 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=1792941445; x= 1793027845; bh=8Z6isml+CFpEVs2mIaGwReU7TxdiukfgakFZfx+OwbA=; b=A MnzhBkuqvHEMHlIt4fLX/XmqQ+qpPq3gH0kLOKYAPMKvuHQB/oC2y0HVQ1dxsIVo zhV1YVCmEq48MMa/AeX4oNfm4LS3q3Wsp0QDu3yczX4Nu4BWZDDLJifB6zC/9Hwi 2hPv561SYlWlP+J5pe3IZColykVTZ/mukwcAuAjtrDlk5TP51beASxPQ60Uq9boI Dk+uoHqFjgB4Tc6Wpk6w3b5Hrz1jb3K75ZZwTUC5Hh2Rkio7vFA+4Yg6DqMDwFM5 FqOFrMs/l8OvfmdYkiAFXe8ttqKUkU1k/f00VcsYMSuN37CMhnNfBBua2Q/+p0lS zIYnQ3Yryqv0YOdO4czwA== 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=1792941445; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:ECxMwWjnsh7Zox+001ltXixl0C5FDqYpnuD51SIOn5YVapa TAlTkGeaYau1iU0KJVzGJo9CL0Mzid9O3ItfaAMlqejAwbrOfMlrCX3KGiR+tlkA BkP+Av8XHidx5VNeTng0LUBAJ4h5TbjgFVUdMTFvp5wDz6nsQQz0/FZ84mQtuSVs 8IYHiRapyDasJU1ll8GZr6Vl7ke6UhBgN3PkzjY33q41o3cQmwupQCZdHbqYtTl3 sg+6lP4GcX1y0wkMSzO814YFflZDAo2vaWuBg3ksxrOK0l/oI0A5fYvi74mt8RBf 0peucGIUsD6/kXmog23dBC72HemaGGsXYhvUaqQ==; 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:+Xtqvsn7Zq2+SjjNyQHZXSrW96A13TOPHGXY5CcQeWY=:HtvjZZj2URFZVzIe5nhzqQS0rDnbZiMFGuIC+J2s+Ic=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFWxH4b7/r57ddGCKGIoJJMiRXpe4jjg9XbjdsvBw5lmLSSajkGF36xHZVEcTiB12 w4yo+UiCpGfGUo9Lf1Xj9ap3Mwfc9QsouEuxx9NJnRedR/hGjoWVbvEdt4Cy7UaS117zXj W2h+ZZKnuX9kps9h0+q8l1aogeq1IuBb6YhdFCrj2RX7DOHfhpYyEgjfp5jmmffllccvAe g60vXXzhHWDTq3xwNWWsDcCsgfvSXLkE7+xJKj6PsyO44B3a5rYAd7H2NyviJH4uZ40KsU KSotz+ZVkzxU7XWDeZH2flU+Klzgl9+H+m5btiVOvyqbcYeLlxbUxsz1OkBpETWCi2okeM BEBjb7IMQFJn8Ji6KNxBz4dT22q1XNAA9eGXWh1RO7eMg6qQlT+/zIPftpUqXPHgckG5it /CaCJ2glat1bX2/8uLwiN9RSypMjjeGEOA8YOUcxgN/fOnu+uZYCPN6RBz/XS3xcbN8Ex/ ASMuwqbeWP8AyVaUhoGcMY1ecONgeKEBgMRdHZpt7u+zKCJqr+ollyJEWgcxPvAS/eUR23 D5uyeoFEw/JeNmlvvd4sorDjF2TllHEvV6l0K5ur2AmpCEpkV6iPBWAzEaHefAexnFeqqK nEIQQAJ8h7LdqszankwQdaxbrVXfiLSDtHF5hGYUYmg9YZUZF41PaVQ8Bdng X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 25 Oct 2026 11:17:23 -0400 (EDT) Message-ID: Date: Sun, 25 Oct 2026 08:17:23 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Debugging --- ERROR: function does not exist To: Mark Cc: Tom Lane , 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 7:55 AM, Mark wrote: > Hi Adrian > > Thanks for the input > > On Sun, Oct 25, 2026 at 2:42 PM Adrian Klaver > wrote: > > And from here: > > https://www.postgresql.org/docs/current/plpgsql- > declarations.html#PLPGSQL-DECLARATION-PARAMETERS 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: ..." > > > In the second case with 3 parameters:  SELECT getSessDbKey (iSessionId > => '1234'::text, iUser => .... > This was called from the psql command line, the OUT values were returned > in the terminal, example: > getsessdbkey > --------------- > (3,,keyFound) Which is the correct process. When you are calling(SELECTing) the function inside the other function you are doing: SELECT getSessDbKey (jSessionId, jUser, 'functionName'::text, vSessDbKey, vSessRet, vGetSessDbKeyMess); There six arguments to to the function. You get this: ERROR: function getsessdbkey(text, text, text, bigint, customType, text) does not exist because your functions signature is: getsessdbkey(text, text, text) The OUT parameters are not exposed, so you only get to use three arguments to the function. If you want a parameter to be dual purpose then you can declare it INOUT. > > > Thanks for the link, for the 1st case I had defined the IN and OUT > parameters in the parent function, I have also just tried the: > parameterName ALIAS FOR $x , but that did not make a difference > > Mark > > Edit I have just seen your follow up message, there are no INOUT parameters > > > > > 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 > -- Adrian Klaver adrian.klaver@aklaver.com