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 1vSh8r-003nfN-32 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 19:43: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 1vSh8q-001SKq-1p for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 19:43:28 +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 1vSh8q-001SKi-0t for pgsql-hackers@lists.postgresql.org; Mon, 08 Dec 2025 19:43:28 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vSh8o-003u7I-2F for pgsql-hackers@lists.postgresql.org; Mon, 08 Dec 2025 19:43:28 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7c77ed036c3so3671416a34.0 for ; Mon, 08 Dec 2025 11:43:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765223005; x=1765827805; 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=FJW1Hk4O2gMGmcK8A1/zswZUOHLfdMBgQtN/EfwtKr8=; b=IrTk6p7+5wSZMl86kuvm6oJBccBl0GZWBOviksxFCjUKPYeOZmkCsPie2UTjSvMJ1o nXD5TqiW2dDdNbzwXSrwpMgCmuC+yuRLDAICjrm83qF2L8DItOiTkgnbGU8784Jj0EPP /r9vmB+ZnmJ8lDIuTowpVo58uSHQts3G5JOzIN/qgNww2MBoPoKAjIOndyHq9tYlNZ2A iA8Gc/K20jG2HJs95j0zKlTL5UrAlkTIf8kph7xcDNSy86XMyoY71YVp/MCNOW8O3DaD X0lphC5u7oRCdKK/3u8bvvmCFuAp5zUz7jYTCj36PqbyEhLrCPGzIOKgzIQLrtoAC0qp s6Zg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765223005; x=1765827805; 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=FJW1Hk4O2gMGmcK8A1/zswZUOHLfdMBgQtN/EfwtKr8=; b=mG1FQ5Nu6SMn9LDsOKcHjAnCDZSrqLc87iE720EEbDJQN62XskpIS/5RE+G6EWItTa skHbTneBHUN+RXHllPB26wHqlqj3Y/2bxZiMvgB7VEifmF/FqUDJAPtm4IM/ljRpA+Aa E77pO5uPN7u47cQeRQ1Cg4lJKE0YtjMzUgGM4MOB5zJAFN/JswAuj2JbukY2Rxhn0FtX 0CHTDcnSqelKdb2mDaj/viGuQVfAeOXvqcE4WC3BsqKywBA4mOXofL5B441UFbRkzN8f VMZfCg00byqPzp/LEJgd+4AUr28i6BJbb2UgcF90G0Pc9rtlg783zRR5CiSHKju8t7Z8 pe7Q== X-Gm-Message-State: AOJu0YwEoNjc8e8H2SNFmJhN6Qu/1W47sE9ZdN8z+gikzzuYhRUb0KuB 6zuHTP6dpOtHS7pptz7zxzdCkhdqp4CZL+22motVxbM0Cui9IdtqQb0IfsmpRMlLmEMMVCLxdMn wmUK3ZwMqzXayQIMIxPQWDemQhyioR00= X-Gm-Gg: ASbGncs6k5mnVNSZ56sqCoQrYm3aZWZPw4eTddlgS3055JE/kbFd85fQm8RXpEIA1dj x2xW7Um9S93nFzU+SIaWdGp42tn5MGFkGA43aumF/ayQ9kiVpnNnUOkHBvlt+qTfhUDHRCI9vr/ qlxG9ujbivC9HW3RLi8IRW+5PkOeBvuS3/CLfeUEb1IjZZg6KPmCXareu83En0RwMxetY9F0+Li Sx8Z7DfojE8Qjw+Qfjo6Pm9lpNh1FP4uKjjR4tOOamR9T+fVW/OJbMhPb0RNqblipaMUw== X-Google-Smtp-Source: AGHT+IHQ8C6k9JgpYb7SrGTGI1fMRyB+SGTBCD8hkP8q405m2jkwDgW/TpvKj/eLHIYEpY8rzK4cR64WfxdJiO26H14= X-Received: by 2002:a05:6820:229d:b0:657:432e:a820 with SMTP id 006d021491bc7-65b1ed6dda8mr245272eaf.1.1765223004711; Mon, 08 Dec 2025 11:43:24 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Mon, 8 Dec 2025 13:43:10 -0600 X-Gm-Features: AQt7F2q2e9LYjuVtg60L8Us0vfrRQh9gJIL62fJiRpiJpqBzCavvrc40sDUCf38 Message-ID: Subject: Re: Proposal to allow setting cursor options on Portals To: Dave Cramer Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I did not look into this patch in detail yet, but I am +1 for being able to create cursors at the protocol level. I think this should be allowed for regular cursors as well. One big use-case I see is allowing postgres_fdw to create and fetch from cursors at the protocol level rather than SQL (DECLARE CURSOR, FETCH, etc.) -- Sami Imseih Amazon Web Services (AWS)