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 1xLLvC-00000001Sea-1nI8 for pgsql-general@arkaria.postgresql.org; Mon, 26 Oct 2026 14:43:35 +0000 Received: from localhost ([127.0.0.1]:36496 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xLLvB-00000005pww-07OB for pgsql-general@arkaria.postgresql.org; Mon, 26 Oct 2026 14:43:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:55110) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xLLv9-00000005pwg-41Yg for pgsql-general@lists.postgresql.org; Mon, 26 Oct 2026 14:43:32 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xLLv5-000000014gF-2hP7 for pgsql-general@lists.postgresql.org; Mon, 26 Oct 2026 14:43:30 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 832801400A35 for ; Mon, 26 Oct 2026 10:43:24 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Mon, 26 Oct 2026 10:43: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=1793025804; x=1793112204; bh=WkW9gwCXKwSD8r7G5xR9oDMjoxS5b/fJYEp6G85t6ZE=; b= ugkwRygIswavC7D9gSUNEzIjO/OvMf2GPtWYM388ziAYHVJT49vyi8K9Wj7qxOnc M4Is4kt/5Ud5x0ia0B32JH7oZXtp2M1hN/tsqfi1yF1fHfnss6bJLYw/ftRuImJ/ UIgDY7Kor+4Ylg/MB9PWCWAdVHRLht/Ta5T1t3AHazntNJHzxjR93ZrqhY2E6CUb C/PKGwt1WQC2uxzRICEM4PaEPjHBaUD7+FC02rPjrMcJGgn5jwk+/hDnTHKbwygX ULqG0/kvmSmMPCaxL1kTDVUjwY+eLORrIdmdH6CEPqwMKbR0HiqaeRiulseRv6yy F8TfgvViplKufg3DzMs3Ew== 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=1793025804; x= 1793112204; bh=WkW9gwCXKwSD8r7G5xR9oDMjoxS5b/fJYEp6G85t6ZE=; b=q DfO6ZUkNSrqCwstyetUPlLVAcLVWPw0tQGBoOTgshkhu6bD9SsbhokKoTOgwQQ+W RrSVn40o91WyP6xXhVPm5MPgBjmfi7czQRgsQEFcmlY2mXtV2wOMbgO5+YuEZBUL S+o66QvO9sZ61mnsXvS47qCF6oR+QnYtsAaaIlI7hV7AuezW6k3heR4NPhCcBmae 5X1dheJpgUYS6PlRTRZUILjwzSGgR0aDWUsftPzTMNEEwlB+91XRDMmBvH5hM3ah xUOJgNpPcGuJqhWJT9XJT1iSUoZaWnbkZpuY4Ge2HrEqAwQROdn3OGUiAaK9ITdf ZFZ8WJzhqQvSJTNWJiGVw== 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=1793025804; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:eQ/OehwE6LMM+1xo684LaZEtZYIjfBlwuT6eqoWx8gsejFN 0sDw6QYGMZtPusSDTaicCCTVgSeQlESWBPMeEibZRrCpvbbzb3/rmUXWHnFQgiu+ XsvTUin20/oHP/rk/uVRUm3TGh1jER2ir6D+s/ERqTzMRscG8nbwXPdVGQq3MUde 4t0KGgRx35xZUSI7k/LcHclRutcy/pR1y3eMQ+x8rvk4Qwj2FurBrAEf9PpurbvT 3Bh+YpTwEQj8H96Mrt2lVuYfGeiajbMxjqpyJNuvHVLb8BRODQTTEy6+OmcDUBWD 78RwHAyhgcH09waVMM2DRVmNawtjOkjf6SF+rmg==; 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:niOKQh+cRqYYv1OkoZJZkXAtAUN6I8oUqQA7vC1dd6E=:RAf4U7xxXxGbOpGA/3C9c/u4F38zhh9jkVclPXr2ocQ=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTExxKBmqOAer+qFRhjyVV95cE/DPp3y+BhPdytflDQayersI/R9K/UvMcmjwgztfB W9ZluM9LSg2KpyEoT4fPPtyB24yPp5w1WYeKT9bl5Adrn8MgUAII6sxxPwepdcTuWW11Ke Pv+kNk45I9t231aGlFcaDnolmHpUOERFXEPTYs2HScWVwqAnsGyULk+bmSQoT10v03x97u 1bAjRi4RVUTFov3skEj+Rkag4Stqm8vRKIGSesRYvHg7qq9ctGSgpNrPaEkNKaMKpV25nT f+njaa6oUqGcrneC5OAPKy7T3dEptKhxpWS4UKONrqCB1T1a+ZhUYEVDzMDxmy+Tu+XcE5 vRoWH6ah+QZwog4Rjz4LpaHA117MJLSR9jUmOSoh4uE3YvT5KHbSnUJckxSNrpOL8+Oq2o nLxuakI8nVs6b1s2eo4pv6uFS1o6D8WgsegsfSZoEflf711D924QioLQ4rsXrJUDE54cDM 3Y5hwHisSfS/lc1PLR4+naPh188lthH32617JUvm42XdPBOXcZcl8OdUB29G1audrNcJT3 htBiVQOBAuap4vGULyDgHE+OOD0HMrTqR4+txM/DV/8fZaAsP0hjcaVajqbnL1bCeqH81w KalyKrCfJthbZVMGcbHKd18dT873anGqBJS77VUftqwFme7gIosDug5f0eug X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 26 Oct 2026 10:43:23 -0400 (EDT) Message-ID: <7a75e04d-7eca-4696-9f4d-8a80adafc6ab@aklaver.com> Date: Mon, 26 Oct 2026 07:43: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> <75654f90-b8a6-42f7-b71a-2591c4e9bc0d@aklaver.com> <335265.1792951220@sss.pgh.pa.us> <96b548fc-65b8-413a-bdd3-345f94f029c4@aklaver.com> <409605.1792959591@sss.pgh.pa.us> <9bc98c9a-f5f0-424b-9eac-4cfe18820fa1@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/26/26 3:56 AM, Mark wrote: > Correction for anybody who reads this later: > > Adrian > > I eventually got what you were hinting at, I should INOUT to supply the > parameters at part of the SELECT, though I feel like this is not a good > idea unless actually required from a security perspective (though I > acknowledge this will be a trivial difference) Given that OUT is basically an alternate form of RETURNS why do you want to supply the OUT values to the function/procedure SELECT/CALL in the first place? That would be something the function/procedure does internally using the IN values, where IN is either explicitly stated or implied by a lack of an IN/OUT/INOUT declaration. -- Adrian Klaver adrian.klaver@aklaver.com