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 1vbm4P-00CnSe-0W for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Jan 2026 20:48:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vbm4M-00BBrt-2v for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Jan 2026 20:48:23 +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 1vbm4M-00BBrk-1o for pgsql-hackers@lists.postgresql.org; Fri, 02 Jan 2026 20:48:23 +0000 Received: from mail-pg1-x533.google.com ([2607:f8b0:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vbm4K-0048Zh-2f for pgsql-hackers@lists.postgresql.org; Fri, 02 Jan 2026 20:48:23 +0000 Received: by mail-pg1-x533.google.com with SMTP id 41be03b00d2f7-c2dc870e194so4774437a12.2 for ; Fri, 02 Jan 2026 12:48:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1767386899; x=1767991699; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id:from :to:cc:subject:date:message-id:reply-to; bh=XFpzy7ZFV9cIT5dbEE7C/pz8r+yAy+4uBBEL9iIcGTA=; b=LIW+Ja+NLW13Xew4euBfnhZ8c25TLc/EdJ8mU8A1dFlTS/ZiLPlJsMaBUsahz/SgQk fjDIb5JcbOOOtPwwEchyk2hXWnoEiumHonjjENUa1GwjxIZPAmR/M8pXfjJwy5tTok5u EGmQUi1N7l7+DNNOVSAN19wSwD7fbADq/d8QWn+YiDg2DNF0/2ihnrGe2xIfUgzlb0BM 34oP3w6NeS+lu+WvPMu0QUtU7yJ7Rnyoq7pkPVI57g5ka+r9yzk5vr8XHX6pPL6daTK9 pPOfGxQTwloWYzukq85soZoNIN8eu/gs83SWH3a/RHxhOSGEw1AtndjXMCujdMDDEquz AA7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767386899; x=1767991699; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=XFpzy7ZFV9cIT5dbEE7C/pz8r+yAy+4uBBEL9iIcGTA=; b=MsBQvPosf1ZeYRfQaQfpp23G8DsY86ZcLnzntBmwy/f/8jAyX3X5Ee43+DvPMO6PrL wjJX9UNvDzXcAeRnTK2jY/bPMJv8vx6GBntNf2hpGQTd9Y7dt5tJKFTfPtBgm63tvZj0 H29cwE4zzTrbF2wVkwhuvRzN4hIGx1/Phee4VIoDJetepczbpI8OJcsdR6+nDtFAloza PKTuBBlVjqK8QkuMYw2M3NX10rRHGmA3AsRMVqEX+vJ8uDEkDSo5kz1Jy3RnIsXsDymm JGnkr+ZNxgHSIFc+paQqbRySvnnK0oafJWa93+a4vIbMXToIKF46BxbthSHINt+NYQzI xlFQ== X-Forwarded-Encrypted: i=1; AJvYcCVPzC+X7n0VlltgDOwaGdR8hICjzMhVoRam9dWBSnfH7oOimNUgj7sCqcSJIv6zkZMRVFaHMiMcX+/rFAkY@lists.postgresql.org X-Gm-Message-State: AOJu0YwI2JMkbVG+SebtEVFtrTireZXqbaoUcP6jRAe4UPjYqCWB6HdL P1El8WEiVHHducXgi7dRC8FCfFsg3sR6WR+znOoxk99RIyrKetswPSaV X-Gm-Gg: AY/fxX7hF8HjSyZeUhJSTmKLpwQeho9qGTd+l4e+/yLnvkxS7nU8rVEe5y7tXyxGzcl 4/9ZHmPzCnfD6R/DmRz7tH8+x2ampH4PxlybUX54umJY4qLXzJE698IRWWWBP2Wpxld+aWnYr8w L39VB0pyjcco5NtQeGYGl9FFLJJjxWO1FTNNOYtrvYtQiah6dMYJMLJIm3J4YstY9TkXMUZ9UaC TdKP9FHI/2dbRm4YXjjYtfS6bYSYLHYCSOeO8M6khjfccWSJclVeImZpU/zXSMpmj9QENraiTvD OaE3uQxVG4PCMr4ZZGxxQ4jJT0/Z9phGEyltqavyG849pVQ3nJOL1J9vNEM5fplJ1QsTgI5eskf dm+dGAbvCbwsIx+bWQgkBt+Wj3N9NCwX2kvqhIx9EtKBcwKtAt6g1v+gGV/UrpCAbUYa01iqKn2 0v5t+A81+1fS8qecb00zrhTciRqaRbbn3Cd+tYuWyxmxOmTqcTN3yDycGgq+bSgolv1P1gzsHGz Ex176KBMg== X-Google-Smtp-Source: AGHT+IH1EbzeKOZYoNGH0W5IwsMKyXJod2mFrswwMrZVewnSxM1TIjsvriqaxBEz0XMcCdy3+KL9UQ== X-Received: by 2002:a05:7300:50e2:b0:2ae:5b2e:9d45 with SMTP id 5a478bee46e88-2b05ecb39c4mr25410790eec.38.1767386898716; Fri, 02 Jan 2026 12:48:18 -0800 (PST) Received: from ?IPV6:2804:14d:328a:a59c:6d00:2898:79ba:8896? ([2804:14d:328a:a59c:6d00:2898:79ba:8896]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2b140c42d9esm1909701eec.11.2026.01.02.12.48.17 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 02 Jan 2026 12:48:18 -0800 (PST) Message-ID: <8dd8ef2e-b5a6-4498-b44d-ab6db966c06b@gmail.com> Date: Fri, 2 Jan 2026 17:48:15 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: confusing results from pg_get_replication_slots() To: Robert Haas , PostgreSQL Hackers References: Content-Language: en-US From: Matheus Alcantara 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 Hi, On 02/01/26 12:40, Robert Haas wrote: > Here is a patch to make invalidated slots always report as "lost", > which I propose to back-patch to all supported versions. > The patch looks correct to me. I'm just wondering if/how we could create a test for this. It possible to create a regression test or a TAP test? Or it's not worthwhile? -- Matheus Alcantara EDB: https://www.enterprisedb.com