Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9Dqe-0008Nt-Fq for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2023 23:54:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9Dqd-0000oF-Bs for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2023 23:54:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9Dqd-0000o6-0N for pgsql-hackers@lists.postgresql.org; Tue, 13 Jun 2023 23:54:51 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q9Dqa-002E9S-08 for pgsql-hackers@postgresql.org; Tue, 13 Jun 2023 23:54:50 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-541f4ee6f89so94896eaf.2 for ; Tue, 13 Jun 2023 16:54:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686700485; x=1689292485; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=KZ+Kz40rG1ZNdIIz6xe2lgKYiReWavwimuv5rKeox7g=; b=KY2g86fFK+IFuXtgQ03fLFC7CmO2kqV3bOpSe2XWRSDtSX4/b8C3tQ5SIViiprEjBe lCnRSB8LgINn9OHbJFH4L/V1ajIM80nPuuEuAmRKOsGQ/m/B8VrkXEn7O//iJv023S65 z9lLd5la7C614eZ+6xIjTR2X0Eg/kZjRIglUunz1nwNi9Bzcq13GkT7oYiecewyyvb7B BTa9xlhp6MTe8yUqrcjCLGVbBa9rJTTwtNq2t1NaKnhjPrma9VJEycBS7EUzcHWCicgv T/xJzL0Udk8KQ3CSdGHh1cXnhXcC4kOtxLOeZpoBRhnASREoPrmmigHKBK0jlk5FXi9h lQ/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686700485; x=1689292485; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=KZ+Kz40rG1ZNdIIz6xe2lgKYiReWavwimuv5rKeox7g=; b=LtdgleDovSLyRSUr53Qic8TvH/e6KajJPANz8dVLl/psBcE4jyuXVI4Q74P5sFg8nf Sn5y8Gi+Bay5WmPe4pE7SYBt2wjssaVN6HqGyl0C4W0uplW3t/3aPCZXoJWYaCxOsMBQ WzgPizzTH4WKiiP7wSxTf+PM1g1gMU2ZnV3ps8k7jhYHyfZKwmzNVxoVLpEjYWY01bNY gWLbJsDgvMz4IzWKiGD0KOMBBJ27UHnTCNvByaguFrz7KxYo7ZWXMCQe58uhI0qCNow6 PhDAaYmQcSnEi5GgmzRNmA5Pr8rWKvW0fSuT1uDndRs2h2LlsRNgoMgQAiFc+A7WOSXR EaWQ== X-Gm-Message-State: AC+VfDzAhyl+9wu8MQinaTw4Ce2gBuKitBObcnfpyx6irPOmljA3Vgb7 s4OPP81XLKUqxraSOMfVC6w= X-Google-Smtp-Source: ACHHUZ746FLMof5ALZ3EiVtD/c//lyD77kIKVW7sW2CC6JtWt7VsJyCjaZvacsI2s8mJ7KoTiz7hnw== X-Received: by 2002:a05:6808:f06:b0:398:2b60:dbf4 with SMTP id m6-20020a0568080f0600b003982b60dbf4mr11231678oiw.19.1686700485453; Tue, 13 Jun 2023 16:54:45 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id bp21-20020a17090b0c1500b0025645ce761dsm9796212pjb.35.2023.06.13.16.54.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 13 Jun 2023 16:54:44 -0700 (PDT) Date: Tue, 13 Jun 2023 16:54:42 -0700 From: Nathan Bossart To: Michael Paquier Cc: Jeff Davis , Ted Yu , Pavel Luzanov , Justin Pryzby , pgsql-hackers@postgresql.org Subject: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Message-ID: <20230613235442.GA222795@nathanxps13> References: <20221218233018.GA1476904@nathanxps13> <20230103234549.GA289060@nathanxps13> <20230109225157.GA1288965@nathanxps13> <7d2a8b72e23c8236281c6e00ae790327f965a8e5.camel@j-davis.com> <20230113203334.GA2206335@nathanxps13> <20230113225626.GA2380176@nathanxps13> <20230113231339.GA2422750@nathanxps13> <20230613211246.GA219055@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 14, 2023 at 08:16:15AM +0900, Michael Paquier wrote: > While on it, this buzzes me: > static bool > -vacuum_rel(Oid relid, RangeVar *relation, VacuumParams *params) > +vacuum_rel(Oid relid, RangeVar *relation, VacuumParams *params, bool skip_privs) > > VacuumParams has been originally introduced to avoid extending > vacuum_rel() with a bunch of arguments, no? Yeah, that could probably be moved into VacuumParams. > So, yes, agreed about the removal of has_partition_ancestor_privs(). > I am adding an open item assigned to you and Jeff. Thanks. I suspect there's more discussion incoming, but I'm hoping to close this item one way or another by 16beta2. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com