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 1xKzcB-00000001EuD-1kdh for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 14:54:27 +0000 Received: from localhost ([127.0.0.1]:39528 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xKzcA-00000003G5Z-2e33 for pgsql-general@arkaria.postgresql.org; Sun, 25 Oct 2026 14:54:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:39112) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKzcA-00000003G5Q-1EDF for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 14:54:26 +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 1xKzc8-00000000ryu-2cYB for pgsql-general@lists.postgresql.org; Sun, 25 Oct 2026 14:54:25 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id 165601D0007E for ; Sun, 25 Oct 2026 10:54:24 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Sun, 25 Oct 2026 10:54:24 -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=1792940063; x=1793026463; bh=rcCdxw2QppEK8fwBhYc43or59H+oAjNiqJptLnsh73U=; b= uN9XRKDSNJbxxO4trDuXfhCiknBVFNKP4RS5cm+UP3rW1RFlUbd/rXjHM8m69gOq 2KFlrbTN2wyxRXF2qQpaFZ5izbAD3V2xKmbtOvIhVJmSQARF6bXsTkmHQKFuXsEQ GT9SZB/eEJzj8BrUQ4d4eyOEegla4hPf54SXK21ytKBim7S+aDB5s+q2bxq682LY RRLxEIjFz/TPRQpPnK2cMV+Kg1MvQ88AyMaCOdrGPcpW9vrBtvfD9ybUfTedEoeL 44zuiTZWGkRhV1kclr/YGC+TuKKLIQbcxdohLI8PjgLOxaPwdJudbMP39rMO1X+A pd9atXdA/KlsG3Kit9+Plw== 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=1792940063; x= 1793026463; bh=rcCdxw2QppEK8fwBhYc43or59H+oAjNiqJptLnsh73U=; b=U 1cfTps/KkyzGDlVDEQTodNL/XwBrUR/70vBf4qsSNTNLKoPOlDwyMfuwcY3TAxTT U35hGAlxDie1Rbw2TS0vOxZavEJs1qo6CGOicdswfG0CPb5dArVY+njLZv+SOU/E eEiIo52tB8UacTpHJ7erh2bMDl/E7jksZqjH3FNBkoL+O+LcPFl2Zmi5v8Bt/pQx uIFpkgq8h4L8tw+Z+vK0S5xpNDgMQXRdOnrzAsZ1MgaB2IGmbMueWSA03ZY8cAf5 Q3PCekuQjgAsE8HuPgaVWTY9qhEftPsDmCWqBa+zDPzODdp8GboEbUnT40IFdOPh XsIhxl6+AyWirLwSkiIKQ== 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=1792940063; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:hFPb5iLKWL5ZaQewZNskRzApT3YFvENJXUOCygy4s5cIwD1 618tFmdxacMbMvbHKMTR7M2DLvkN/C+LBiIEOxW/4nv9tdcLhe22bHHsq2hlscGD bK8JQLnMhTkq4aa1dlyjUNeaaeuYkP/iCP7e2Xl8x6dGXt+9XGsefk+PjmXsZMt2 OZJ5GcMWciw2w3QWzN2E9iNYBKsYsAeF1iTL8qmTigu2CZo+zY5DIe2KlohSHWh4 X00I2H4cIFDbiHiAsirJuEI/Rt2LvMsX+01jUfMv6PGEP20vSRGDt5KMuT3SjP/a 9w4ajnRhQHk2OCwa2H50oxy69I0A1qdZBSckCaw==; 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:uFrOeWhBcJl46RhFYmio0nOOnJWMd9jGaN+KCuOL8ik=:CPC7oFj4ACTwT1/D8gC5ABufs6G+MtdVbOtvoVZihOY=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFxB8fQgTIMcwqWDkhoyw34GCnWrvsJua8ELWT/ATO+Gp1t1jXm1ez1Mvaa/rAGhE GIHVVC8RD0wdN+llaWJBouCI8J9QIkEfHcYCt3EMuPrKqu95ZEZl3XvREBHb8AYtTSnAzR CX6maDdeW+1xKpLTFfJLojtqumbnx3iXIBQuduWcqnVg85ZNIbxLoEl0A/H7LBIqoT3rzz RmwHSzWL5YcXq/3cdi78BMJVyaimfEDABbOFv5yFuWiOwz2W1q3VFm2xL16ppod9xNjSJX IXamrQxRNwQlN6/3w1veJHkJlXBbPVU1UW4C+NRN/1iqAIYYJDUE/qG2Scss2dAD9IfBkG fA5mMdv8qqYr6U7d0prlftx3MTzCbWbQYHkbQueOuJ0NAhuDXKKYdR+TjvTXgtuUbBGreq YP9vBLmh+uyDMz4v2iP/LU/OTti3uVV9seoANs79xrgGjG36DCM4Tn1dhaQv3RmCfw7o1T xS4yV1BtWDF3z3/71Oq5ZYFxZMYKAU+4Y0Jh8LPTpjX+fuG8vet3cCvB8Jerc/VYteRcyb KQj9MoKASntUzoO5CiD5aKFH/BE1VSL6WxKPNVXtiq9lS4kSa2YxT6u05rJc0EZYdtdfmJ 2QlXj9za80WXcnczeFpAyOaQgdwHczln0gKdwPrD4P4f2WIwZhQzDYfrlQGw X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 25 Oct 2026 10:54:22 -0400 (EDT) Message-ID: <941f31ac-e44c-4f10-87e8-1e0ab19f7206@aklaver.com> Date: Sun, 25 Oct 2026 07:54:21 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Debugging --- ERROR: function does not exist From: Adrian Klaver To: Mark , Tom Lane Cc: pgsql-general@lists.postgresql.org References: <322082.1792933209@sss.pgh.pa.us> Content-Language: en-US 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:42 AM, Adrian Klaver wrote: > 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: ..." > Forgot to add there is INOUT if you want to use the parameters either way, see: https://www.postgresql.org/docs/current/sql-createfunction.html "argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. Only OUT arguments can follow a VARIADIC one. Also, OUT and INOUT arguments cannot be used together with the RETURNS TABLE notation. " -- Adrian Klaver adrian.klaver@aklaver.com