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.94.2) (envelope-from ) id 1rTZPw-004Gg5-AB for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Jan 2024 03:31:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rTZPv-0048ew-35 for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Jan 2024 03:31:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rTZPu-0048eo-QR for pgsql-hackers@lists.postgresql.org; Sat, 27 Jan 2024 03:31:38 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rTZPs-003Zjf-7D for pgsql-hackers@postgresql.org; Sat, 27 Jan 2024 03:31:37 +0000 Received: by mail-ot1-x32d.google.com with SMTP id 46e09a7af769-6dde5d308c6so774474a34.0 for ; Fri, 26 Jan 2024 19:31:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706326295; x=1706931095; darn=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=SEpjgxQuu/lLThD0g7TuW3DjKYBPXLGLeFZWYOhV+NA=; b=f59V9jbYbxFA+qq94uQn/9tQ9sIEo/QFVgwrymZ+jzIig+LFAxcleVEeDoRzopcoh2 1vMnYoh6RvixMtp0qZEO5pLm1Syhuj/CPXWmfFIgJ2fbiL214+XOWPc26W0sfJBtcNFw gswmIw1Aj5NZhq8/nGODyDDg3EYr4plchRq58DJ5KiErevgIttTjFscuzShXY+q2e0nu b/J29vau6ij/M8hl5RdLIierHNAghvNFoxgw58VR14L47H2EEpYoxi77MnFiarwka6OG 1lC1PLA4VS6bnddbJDI/UGhXwAcA5kVVSOSv3/I9Vz1T4cU8yGhxS73xdZdKY9qwYJ9/ U+uw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706326295; x=1706931095; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=SEpjgxQuu/lLThD0g7TuW3DjKYBPXLGLeFZWYOhV+NA=; b=l7x1ge99TCM8XzShHzbix2aNHUirRL/sQ3ZSQ0hySF5byOEA5t0GuNzRPFV+yY4dOG vRL0mIGqWMEAMjClsAmpYvixd+zTWad3w8vFQSlu0VLBlWIJ5v+L1qG3/Au0VaOB/oEi GdCYW217mFBRVNO9IETvpAh8DsXTWMHtzMWg/kgZgrA+nJ3Swt6rGhyqvgjCmw5W3l2D GlK9UZyZxFGwfuiD/nWQnD62eghkSaqUnnS7Civ0YaiYow2nz/Q6bAb8rG7EMsa6BTFL ZdwiYVAiwsCAXuhHE6nrcqZnBmR34Gyb9OSx8NS9SCm0ZQVKREB+dM/1mS5lrXO6bmxv ey/w== X-Gm-Message-State: AOJu0YxXIxIa3ciRUH3cIygBFf0mYZafQMTKX5ZhbYKoQY/Q2WCTJTzN MIMiluWZ9YpgOQekJjkXh1k2CcM5/ZTsmA/hb2vmVAZZKbJeGJFCzt/g8KO7Rd7PdR/KWdjwUYZ dr0EVurznGf24duV76OvitAyUOtw= X-Google-Smtp-Source: AGHT+IGX6ANEmmGN0ILSnFEK85JmEefmGEj4AgmEl0qtdw4tXxB4StnQGwJ6e9l+k9MgD93ygu7IdN0/647caYVe+u8= X-Received: by 2002:a05:6830:1119:b0:6dc:854a:3d91 with SMTP id w25-20020a056830111900b006dc854a3d91mr738809otq.30.1706326295337; Fri, 26 Jan 2024 19:31:35 -0800 (PST) MIME-Version: 1.0 References: <202bae70-f60d-4d24-a8d8-50b4ed638887@manitou-mail.org> <533b71ca-f0e1-4f64-995e-2849ca31296b@manitou-mail.org> In-Reply-To: <533b71ca-f0e1-4f64-995e-2849ca31296b@manitou-mail.org> From: vignesh C Date: Sat, 27 Jan 2024 09:01:23 +0530 Message-ID: Subject: Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs To: Daniel Verite Cc: PostgreSQL Hackers , Tom Lane , Robert Haas , Jakub Wartak Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2 Jan 2024 at 20:28, Daniel Verite wrote: > > Hi, > > PFA a rebased version. CFBot shows that the patch does not apply anymore as in [1]: === Applying patches on top of PostgreSQL commit ID a3a836fb5e51183eae624d43225279306c2285b8 === === applying patch ./v5-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch patching file doc/src/sgml/libpq.sgml ... patching file src/backend/replication/libpqwalreceiver/libpqwalreceiver.c ... patching file src/interfaces/libpq/exports.txt Hunk #1 FAILED at 191. 1 out of 1 hunk FAILED -- saving rejects to file src/interfaces/libpq/exports.txt.rej Please post an updated version for the same. [1] - http://cfbot.cputube.org/patch_46_4233.log Regards, Vignesh