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.96) (envelope-from ) id 1w4r3J-002ciT-0y for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 01:59:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4r3G-003YGW-1J for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 01:59:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w4r3G-003YGF-0M for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 01:59:26 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4r3D-00000000nW7-3CgV for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 01:59:26 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-b98133bdc4bso579077666b.0 for ; Mon, 23 Mar 2026 18:59:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774317563; cv=none; d=google.com; s=arc-20240605; b=bQUMnCZkyoGWevSb3LbpvRTCi4lzWxWmSflrXxNrt35o4cTYmTuRESTGkhN7iUtXOp lZyvAa4UlMto/16Qw98f0psFmqOrtSoQ+EFL9tyMwzyjF+A8cJOaDvQxep19F+5sCBgM P/V3GdyYZK/zYwbSY8S0MTttdLwJmuTvjzIzS3PIIMvtMEG3hEzFnC1pU/GIaZ04K4o0 XEmmmSDwgu7G9oliHX0X7iCnLuAk3Z3W8R4mbViyRT9SjuZcBYb2f8h7rwriqPCGqJpm gDUQl4/oJnNjz4y6LlqYKa5/RsHHAufNrsZrgoY8Eu/nIIon+prVQOu/kCQcdiQsdcvu HfzQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=6+Yxrwo6IY23e3FD2sqqQ4G+VUsE0E3J8qB/qYFNJz4=; fh=6khiyAZjgKkqgUw0HgpQjh4tvnTN7Kw7enHd8wvOrYE=; b=DIiYspMXTCuDE3SzlHzB+eHd5++oeRkF4SvXCPX1+4sWxm0/tY+OdbS4KYld39hyGF nFy8LRBWTQ70gI18OA0TI8NEc4gsZBLqhbypfcutUm/hXCZ3ABJQM/iI55UVLP1defUH yiCOo1bLlUoV/UEnz02gExO5WKvQiiq9lsmKrV85eWqeFvngrtG6a05AOHwIk9TFC5zS VIQSri/cthsoQIkdN/0+Hs5XnVUJsIaPod7/QiguY6Fsg3QyUElJq7z5MD0klkVxv47F /xcE3pvGX9xZ4C3l1fJK5Kz5lg+KZjZFtpmfHDoj+7a+TaROAUJN+f2IhrGFKd3q/w8i saCA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774317563; x=1774922363; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=6+Yxrwo6IY23e3FD2sqqQ4G+VUsE0E3J8qB/qYFNJz4=; b=PxsWmTo6HnVMuugSHO8MWBcHowiQD8QF1dz6UFS85zKNLMJ2KNVbsFqZTso7mqeLKS Br/5LfAuMhwd5umkfPVbFrqHsQ0z8Zh6a/roZxz567D5qCnxqcFdcc9uUomTn2HOc/Q1 b35+n/7z0PiRNxzQZf1MNvz03raEKzz+L1UJRJR+XntAvToC+/jrdbgWJWv6qFKFLLTv Vx0uNpub6P69P3FF43Jo+0w8CDeSj+yBVVnzVg6ARd2laNOTdlwX0JMaDXQPJaAa6o2X f9/FAK4tr8GIER8xvrc92E/YwI3TEQTAj9Hcn4magLZSVR369MjbQTHA+eQNpqSArk44 uHyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774317563; x=1774922363; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=6+Yxrwo6IY23e3FD2sqqQ4G+VUsE0E3J8qB/qYFNJz4=; b=oOfi0Ky700DqYeZcBMpJeutbS2abScgo6FDTlKl6nljUFs00ba8tvtuZZLDaETAgNq KNQVMOX16598bCQ9a/od5AcY2JdSP5ITh8Uw3Lg67pNJEwRxA3PSg13lt+R7c5tcPKqq EP+RwA7KXOWEdti9F1CZECIhUG1ZDBTquKyl/Kk3LwoMJ+hwoYc/eK7euBrzAca6ZN22 gdyBag5LNy4C8Kdl+dWmyHlztmWUtoCNfMUj/uTaMCBUcM5lj85MJrDFW8uafrFFTS/1 yux3Vfobs/c01Jn5VT4Rk1hc6d0PfR6hAydZ5VGKXoVFT/u3Lvym1Sea/VEqhRp7ik7L OIZQ== X-Forwarded-Encrypted: i=1; AJvYcCWyYgbvqdPcHUwxjiB3fs/QQ/L50vxShcqS7S8SJ70YDhOZ+6w7mizsuZTkihPGofwbwglodIlPueWkwT1N@lists.postgresql.org X-Gm-Message-State: AOJu0Yy9ONl7aAJOT8zLdFDNjwUOKwh9VXXKK065t6OqB5k3E3YIdsbE VO6osbqIGh2hlPgq355IvWvOIDxolWZbywCbQQC86FHWlI75yF+U26DwDd463a5u+G4MGWDF2O2 ZXkWtrZvbJnDeohMtNA9pMl0v7uiCRIg= X-Gm-Gg: ATEYQzwheEbhuK7GxSG2Q/NP03sX3l5yK80mGg9SseqW/ywJ7uG3imiN8HDvLx0w7+O 07SZ8Sk16SpwyWU9mNUfTc252OBxVyUnNF+WijF448fwbv8EquukXSQqSe/esAKP/rbArFWLV/z puZAsQQATWUE3uCT0l3XAiG3uCzcxjUeusesudC8Oue+KyCQM7iTgs8FPYTX2pERouSm77dD6gW i5lbfxL/K0NXeLtpGkE5UTK1Wymm3hfZBDgCZW1WpZ0X7TlB4EIjTnQDzvPVBnEkzMux2uv931R iEEFkw== X-Received: by 2002:a17:906:33d0:b0:b97:a03c:6f4d with SMTP id a640c23a62f3a-b982f3dbe68mr802063266b.56.1774317562979; Mon, 23 Mar 2026 18:59:22 -0700 (PDT) MIME-Version: 1.0 References: <2155281.1767900170@sss.pgh.pa.us> <431484.1768433414@sss.pgh.pa.us> In-Reply-To: From: Sami Imseih Date: Mon, 23 Mar 2026 20:59:11 -0500 X-Gm-Features: AQROBzAAeXd3tVFFQFC0zNPhB1b2hZYjVkujFqsRPZDBQf6In23fBW7xBhzB13I Message-ID: Subject: Re: Proposal to allow setting cursor options on Portals To: Dave Cramer Cc: Hannu Krosing , Robert Haas , Tom Lane , Jelte Fennema-Nio , Jacob Champion , PostgreSQL Hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, One thing that just occurred to me is why must we limit the new protocol extension to holdable cursors? PQsendBindWithCursorOptions() will work with any cursor option, Maybe it should be called "_pq_.named_portal" or perhaps better "_pq_.cursor"? -- Sami Imseih Amazon Web Services (AWS)