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 1qlvC3-004siX-7Z for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Sep 2023 17:52:55 +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 1qlvC0-00F1dG-Sn for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Sep 2023 17:52:52 +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 1qlvC0-00F1cf-E2 for pgsql-hackers@lists.postgresql.org; Thu, 28 Sep 2023 17:52:52 +0000 Received: from mail-pl1-x631.google.com ([2607:f8b0:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qlvBv-0079mj-3A for pgsql-hackers@lists.postgresql.org; Thu, 28 Sep 2023 17:52:49 +0000 Received: by mail-pl1-x631.google.com with SMTP id d9443c01a7336-1c737d61a00so8396085ad.3 for ; Thu, 28 Sep 2023 10:52:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1695923565; x=1696528365; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=VTsftHPq8tC0nDCqMRnZ8cxu2hGfTfilxy3d9rZa7d4=; b=DqYaNakL1ENEsa3aPJ/8yZd0o5Yf+zx/tMYlj1LZzxs/uPoLFw+1txkPTz/VEILMuk Bv5x9FAWZjKQdbe4XS7sXEsalR23PuVxsCz3khCZ346ifyTgx41KPGTG5Ek8Eh53Mir4 F35VsrK9/ONuCFBjxVbnlrfgtmFnJNBZLwmh4U7KJ2S5b5MWfUp1kNx7qXejGtIw0VQ6 qhr4flgf4b+NF06NTqaJyXyC82W/85tmvWqlq52BcLCvOYhkeSdYbJrE8vzg+KiRHczi TRH7x4B6YiFqnSWVINvvnq3T0yhLgI9PP4/k2wP7kBSfxXI42BPo8KLtLS5r4bdr46B1 t9/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695923565; x=1696528365; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=VTsftHPq8tC0nDCqMRnZ8cxu2hGfTfilxy3d9rZa7d4=; b=IVgfptsd9xuCh/BInyibthCPX0w5G9Fqsarsght5XU/MOY176qDAU/Tg1QVIqT5UYM Ed4oMq4pOGP45FT81W7V6/9drFpPH/PcnhrishR/UXDjJYaaTC/mFt+MYb+eAr/8NtGA JDgBz8QhSDRkulFS5y+Dqsj8+AB3GIcrOjlZ6rpe6u6hKmX09+yREgpmMkrn5NfGnwbj WQ5ZfMQsdhy7m9q3I4aTimqNFqVpHemFkX6tWeELjYzIFRT+v2LvKF0L2jZu3770qHcj rO3XLcsa7UOJH4TeqwvVtfM3SF0OkIJ8i6WO5o9xegF+NzD3951i3OXdLZO04VM90lsl egmw== X-Gm-Message-State: AOJu0Yzr3EB6MPhmrMaXMuq8hrWcoljeNAlzqsq3daaeeg5cQmLCWp8D pyTSr6lfoNpT6hVXHOc84tYgtw== X-Google-Smtp-Source: AGHT+IHHFfJd27t1lVDIhheOZ10jDMhcIeIxh30CExwRoYRQDQjKP27/a+0i1A4FZ1FKr4g+2SAnWA== X-Received: by 2002:a17:902:e849:b0:1b8:6cae:3570 with SMTP id t9-20020a170902e84900b001b86cae3570mr2222188plg.11.1695923564979; Thu, 28 Sep 2023 10:52:44 -0700 (PDT) Received: from ?IPv6:2607:fb90:371d:374:9d87:a57e:e72:913d? ([2607:fb90:371d:374:9d87:a57e:e72:913d]) by smtp.gmail.com with ESMTPSA id x11-20020a170902ea8b00b001c5c370d4desm8971090plb.246.2023.09.28.10.52.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 28 Sep 2023 10:52:44 -0700 (PDT) Message-ID: <1089c63b65eda736d5c6e9ddbf64cfbe65017373.camel@j-davis.com> Subject: Re: Invalidate the subscription worker in cases where a user loses their superuser status From: Jeff Davis To: Robert Haas , Amit Kapila Cc: Peter Smith , vignesh C , PostgreSQL Hackers Date: Thu, 28 Sep 2023 10:52:33 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-09-28 at 11:34 -0400, Robert Haas wrote: > I guess it depends on whether we think this is a bug. I think you > could argue it either way. I'd suggest backporting to 16 unless there's some kind of difficulty. Otherwise we have a minor difference in behavior for no reason. Regards, Jeff Davis