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 1uuC9u-004R0K-3M for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:45:59 +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 1uuC9t-00HQJu-B3 for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:45:57 +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.94.2) (envelope-from ) id 1uuC9t-00HQJl-0O for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:45:57 +0000 Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uuC9p-000YYO-1q for pgsql-general@postgresql.org; Thu, 04 Sep 2025 15:45:56 +0000 Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-31981fa3c89so905665fac.3 for ; Thu, 04 Sep 2025 08:45:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757000753; x=1757605553; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=3tboOssIsbSSomp3LEQXSzR28ObLzU7+72FXTa/+Mn0=; b=maEZ9cfuJXHh1RycmL7h5TDiIJU4P2P5GHDrjy+5UtYCPuDIFkkyDop0N/5jRKqMTW XYVMaECLnHPtt6yi1YrHw1nR1NN7w/wDaOfbzfSec9FLI0HJqCupG1cpeyKAQCxh+CSh uLuZqxsM+7GrmtO5MjvF3kyRL2JNt/kFv+I8mQQlfkg8ZsFI14GK4la/Fucz0rHPBmG7 bNuKVG6e5CY66u7vuv7eDbqDEInVb08UyaalqYplzouO8POb2e/Qy89l4s7DanEpF4/n 41vJ0fNTKtBJmC+oefXBitSau/zHle7BU02AUOAkOY4WlK4HxkBzLbOGmR/KpJdcMERM JsOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757000753; x=1757605553; h=content-transfer-encoding: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=3tboOssIsbSSomp3LEQXSzR28ObLzU7+72FXTa/+Mn0=; b=StTYpcqJtbLP50VwY1gfsZ7vgvJxF4kTfcyTu9X4q4Sn2ZQeshiCqzntgvdycfqzqA CEBJgvarTBLlRc44UbtyJHhlO2l3v4jcWmTFOS+LrKarfHRNrAugw8OJ74egmHjs+J7D NUBa6yHtwyq6ph3KxU2DVavdfAyEvGULB6eHxMw1VjasQqLaFmlpunyZtNu4XxmYzU9U vGxKxA047+37yFT1HXRiTYhQnLSaQ8VGXtZZZbpFWXrY9D9xLKn0DVJrtohq13Nywhxb ctQpCR4mufdzLzAWWCB+vCY54Q4jbtYWonpXWrDZCof6KYTdBJgx314tHI5GB01nhgQ6 O5GA== X-Gm-Message-State: AOJu0Yz/3PlQ9fkH4J6L9stMeyKp1JVqAwArLofTau062aBaCkxdCqqf oKLoUH7FEeWdFSIGC2B32zmOeS1w32kLeVHwAQJqigPwFmdssWdMSo2CTDAMxWZyXFvAps4n0SC Zq+yvxtnLl6FKcx8mvSY9ZC+MgW/nKMw= X-Gm-Gg: ASbGncuvuHNOE89r7JGglIsC6HQ6SAZ3C3RTN2E+4iCYxNO64zWDmNFRurKJZlw3+cs iY05ZkZwTCPD4Q/c7skTiDcdZaJwRSsHSvTf/sTQaag3pETM204/Ifbhfrl/jrBxypXOh40RVma ewNDlmQujAaP5weBhN0FgbNIdvOsXVzrl7NTlWBobRb38OSNg0aLNzY0YgynyeTWuWySg1LEWoL 0qhpqETNA== X-Google-Smtp-Source: AGHT+IG9zcvkE6C4vRiTfBTPucAsRWbfTn+ALm9hJlyGhSypnuo7ovipS3G+w7ltboAQAu4887xEMq/WAwJhYLyK7MY= X-Received: by 2002:a05:6871:4e49:b0:315:6ea9:699 with SMTP id 586e51a60fabf-31963346fe1mr10436175fac.29.1757000752837; Thu, 04 Sep 2025 08:45:52 -0700 (PDT) MIME-Version: 1.0 References: <7132f28c-1437-4723-a363-c19b99a33bec@aklaver.com> In-Reply-To: From: Dominique Devienne Date: Thu, 4 Sep 2025 17:45:41 +0200 X-Gm-Features: Ac12FXzlJLgZrxVeV8L61TX_ILe-DZBgDKwZFgpe_-mbtKx-MJQ6YYEjnW2MqT0 Message-ID: Subject: Re: Latest patches break one of our unit-test, related to RLS To: Adrian Klaver Cc: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Sep 4, 2025 at 5:31=E2=80=AFPM Dominique Devienne wrote: > On Thu, Sep 4, 2025 at 5:12=E2=80=AFPM Adrian Klaver wrote: > > On 9/4/25 08:03, Dominique Devienne wrote: > > > But now, we've ascertain that a particular test is: > > > OK with 16.9 and 17.5 (we cannot test on beta2 anymore) > > > KO with 16.10 and 17.6 (and beta3 too, released at the same time) > > > How did you move from one version to the other? > > We first upgraded in place. Broke that test. We're still naive I guess. And didn't expect a minor upgrade to break us... Given this mishap, we'll do the reverse from now on. Install fresh clusters for the new versions (minor or not), and see what happens. So we don't "advance" our main/primary (testing) clusters until "issues are resolved".