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 1w4yZo-002lSw-2F for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 10:01:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4yZl-005oFi-30 for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 10:01:30 +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 1w4yZl-005oFa-1z for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 10:01:30 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4yZj-00000000r9k-1m3A for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 10:01:29 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-67c2b70124cso2065022eaf.1 for ; Tue, 24 Mar 2026 03:01:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774346486; cv=none; d=google.com; s=arc-20240605; b=E81WCLp+2LOIHYQscZSgZ6ZLBlrGb1ggH0qRhrYiHc4gzcNSsglb198xc8bhwCsFbR ZYKl2LyWSKGNpBOdt7ExyiVyEZ1+nobIDEeAanvJG158vFyg9wDXSMl49ar2xDBNJRYv jwl4sPWaS500qGMD3AXiKgjvR9llm1GP+SrTbE1VSNCMQ9uS9/IRT8BN+0RaTiBEYX0v pgemHJ1kDB6A/l22IV/VxGtJoGV/RB4MEY3jXrR4sNowJ9PWiFmwsqLjbkPirbrlqECp FBsZjA60XWKLjJ7qsNxMRbs4I6nTL/yFBLSrCtY5hoHYa3evARypSY+MfvV9/zdqwXMK ZNHw== 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=pgr1WDCCWl0qK8AwEQAPcV+e434UjM+gpdgrd+h0LxE=; fh=YZ3hxlnR5S2A5mzzL2UgkF/kLxgzZQAVcVuXg8D4MIE=; b=AOpRbr/6elWvjJn04Pxx8R4ZKt8qu1vSJG9wMiAaAt9nEcX6Wyt57DD7K7U3Zfzcwf UxfanKm46VAzDtAD7T1XHIM6xh5arnbEpjeSD1Q0pe9BR0VkaBhaCoJYWjUNbp4yHF7l JFNuX+6HYJi9+L3W8HmsCkMmU9O7ZMcr1C6o+0c8JlZVx4pbS7P1oE3p5p2yFBPiGBx1 HxA9fqDSobRYtLtD4IIyeG4CSumG1BO6baxNKxruAf/qVbJ2scmzSWgHLHGz9QlVMks6 2pDFDuEwUiOk+C+PMvRFvbGjzVWaFdsrH7XnMRlEU2JicYtQst440FRJSwtZU+8Ba7A+ ZKLg==; 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=1774346486; x=1774951286; 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=pgr1WDCCWl0qK8AwEQAPcV+e434UjM+gpdgrd+h0LxE=; b=hMDIkUH2fUYFaoJrkAUdxvk8AmTdPBBciSzqBlI2N2wH3J30lONu0ggn9rsEHP0zpy IWLee6B0poNliVicFaVvK5I/ufgdpzi9siL7QIE4WqnVk9Aj4FhPl9+rD6AL8bMDNDcN x3NETDTKgRBCcQ7zLEG0hSHhFdT3RiCLOq3pkolBwKjlb+gtQeb40X+M0uYv7ls4YPCI kJy27Oh5q9A01mVccIsfRHX2NKyMymUnt/vLGjZWjyKemhl4+kJ8N3GLqu6jDF+nSN/s tt2QwQ1/uYMXmSxAzotBnY8Cs4kFZ4c/JRUo+fEcv3/ihzVeXlUbnZ6NwU45d/dvFx/U omqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774346486; x=1774951286; 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=pgr1WDCCWl0qK8AwEQAPcV+e434UjM+gpdgrd+h0LxE=; b=oO2IMRjLbvhadkzV5pTxic8RmQHCQtlVu08ydcvqjOEjhyQdZ5666BehJTvJjnplGL 4SyuO2kArODdTCJMa4RGtAf8h8ajz4Md/rsaatmtVuzk4MFRJwBNTF2j7dEixNm95AGP jjXAEztX/8A6oM0EMHbVdVXUOuyJ2qZfnURwC9go9meL45Alitdue5Ra65vSnfrmKLwV jNf/ebnkJ7JyHZnV7jQ2kniMAy0QALBnapiMviz94epDDySKHqJT7RR55cqRYp6jiG+2 81CWYmlqSxg3oNmtT1nHzbU+Nn97zazEqY+pNqPWFsxXGbS5jCtzbHObz+R3JJGzkHau oh7w== X-Forwarded-Encrypted: i=1; AJvYcCU15fUxWQneyfJZWjIk1jh1dB/F7Ap739MDkeRFwTbEwdLrXj5KiziR/5yKHtUNgVAhObcm9XqEeZiscAYx@lists.postgresql.org X-Gm-Message-State: AOJu0Yyg06X97dSC57xGPWM5gB4PnIwPTT7aWXolofOHxilzEgfiyQD9 lsiqwK7GbsYc55pTKvS+DXAp77IG6XqNvxXTXFBqy2K5wVMMuqNW45IBXqh95c49BdBXU43W+5k /ykYJLS1AqrtNtWl4RgpJ+VYy+Hi55Zo= X-Gm-Gg: ATEYQzzNFJkMupDT/Lj/A5T+zRmmXbJTi5yHUURYDD1+n02Rx2NRqbIbl6sZ20ijisL apb7VSSPx41q5OMkuwjBa6N1gNZ6CCEIO8YVpA+939+l5sl2VS9B6vRleATrQglg1+gdhDTK27D 6bgFHZQIqD1o24TztX+kH9k144iZ5pIvTX4Q/OyzjQpIE75qcTLntdjEN4NV7XPL2IulK8SjxEn HHjFZc9DNT05FqHyxQXHdQTvzC/nN/cOhXIFeBfEfjX0+yQPwlJ2UKSxUQHndCPhcLvnhQ/K7OL 7dPWZg== X-Received: by 2002:a05:6820:650c:b0:67c:27a7:8c3d with SMTP id 006d021491bc7-67c27a7961bmr7366161eaf.57.1774346483193; Tue, 24 Mar 2026 03:01:23 -0700 (PDT) MIME-Version: 1.0 References: <2155281.1767900170@sss.pgh.pa.us> <431484.1768433414@sss.pgh.pa.us> In-Reply-To: From: Dave Cramer Date: Tue, 24 Mar 2026 06:01:05 -0400 X-Gm-Features: AaiRm51XKw3Wn8Qd-CEPTr7d8k1az9eAig0O2hNwLYduJy2TYyG8HPSrkJHUvkg Message-ID: Subject: Re: Proposal to allow setting cursor options on Portals To: Sami Imseih Cc: Hannu Krosing , Robert Haas , Tom Lane , Jelte Fennema-Nio , Jacob Champion , PostgreSQL Hackers , Heikki Linnakangas Content-Type: multipart/alternative; boundary="000000000000d6df46064dc23b57" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d6df46064dc23b57 Content-Type: text/plain; charset="UTF-8" On Mon, 23 Mar 2026 at 21:59, Sami Imseih wrote: > 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"? > Well there are currently ways to name a portal with V3 so named portal doesn't make sense. _pq_.cursor would be fine. Dave --000000000000d6df46064dc23b57 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Mo= n, 23 Mar 2026 at 21:59, Sami Imseih <samimseih@gmail.com> wrote:
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 &= quot;_pq_.cursor"?

Well there are = currently ways to name a portal with V3 so named portal doesn't make se= nse.=C2=A0

_pq_.cursor would be fine.
Dave
--000000000000d6df46064dc23b57--