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 1qBemd-0001SW-Ii for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jun 2023 17:04:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBemc-00084Q-DL for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jun 2023 17:04:46 +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 1qBemc-00084F-41 for pgsql-hackers@lists.postgresql.org; Tue, 20 Jun 2023 17:04:46 +0000 Received: from mail-pg1-x529.google.com ([2607:f8b0:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qBemZ-003f2c-DU for pgsql-hackers@postgresql.org; Tue, 20 Jun 2023 17:04:45 +0000 Received: by mail-pg1-x529.google.com with SMTP id 41be03b00d2f7-553a1f13d9fso2696469a12.1 for ; Tue, 20 Jun 2023 10:04:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1687280681; x=1689872681; 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=QauG/0XIJXaR74agLrqIPEKY06AOQbD+iInnmeAzEpQ=; b=ycbokjeTSUdNlQHYJKyRxBGFW9zicCayLJmUeOSpVo6gYUCcInnI5V+qz0z+qRiA2I VEXi/1qxZqJsiwMU9c+qjw8i4wSDidPVzTKjt40+apq2sOkUTcmr4F1g/s7QxMCgCiPI avGaS/ZxqZh9ab7Ow+veLEKnhr/i4ymY4HD/nc1UbEx8iZbF7euodQAIC1FhnwB+T+Je eoSUKzk6cAnmNyduHlDfwk5TUzaWmTLeuWJ7nXrakx2zkB7gvzwPht0EhQeko4UjSHWb TFylwp/fpLeWdth1bq9k1eBQ35SsonSfedRik8GpllLVsPYYp+lel4RceFMpyGr5lX3h iE+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687280681; x=1689872681; 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=QauG/0XIJXaR74agLrqIPEKY06AOQbD+iInnmeAzEpQ=; b=AxAW+ztXrYj2arXCLdK2WWA93SY8IqVcJFU5Nyw3+aL2622++bH9ZY/IrSLxzjseoA j+pqUCQj4NbznvjTppPRsmKHfQUc0apbKQ5aTKa0ibTUARjc26JL4N/yyr/rYPZSXUUT ZJkIhH4tGNEVymm60CVXFX1CTGEhhqdNjckXr2rZa/rv5+wK5qcMs48+DeoowTq0N1Jh NRWhf3QimzdLfS/oi19SszWKmZzlpXDLPKpjbnQUj/rYYtoSSdFkG+NrrA+MUFPWS/jo HRSrhN5VORO7AGggWBmcC5z5igrRRl0RNaGmPKOQq/VLSc5KVpaV41bRzWSyhVenqbNs a8jQ== X-Gm-Message-State: AC+VfDz7wavLOT6IQmpZ5bp5ejULNjpEy8YJfwfqa6dEP3xqsP54Gh6B NzDTm8Jik1z5tiJgpxA5GoRNYQ== X-Google-Smtp-Source: ACHHUZ6nQNMKgmWW1xSWNHwR3E+h5i1ysTXhaguELbCEurqyxHOxOOdpnL2f3tb0ZTEwOBdxj5C6Ng== X-Received: by 2002:a05:6a20:841c:b0:119:c5a2:b360 with SMTP id c28-20020a056a20841c00b00119c5a2b360mr17691796pzd.12.1687280680746; Tue, 20 Jun 2023 10:04:40 -0700 (PDT) Received: from jeff-laptop.lan (c-73-170-46-202.hsd1.ca.comcast.net. [73.170.46.202]) by smtp.gmail.com with ESMTPSA id a23-20020a63e417000000b0050f9b7e64fasm1628250pgi.77.2023.06.20.10.04.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 20 Jun 2023 10:04:39 -0700 (PDT) Message-ID: Subject: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX From: Jeff Davis To: Nathan Bossart , Michael Paquier Cc: Ted Yu , Pavel Luzanov , Justin Pryzby , pgsql-hackers@postgresql.org Date: Tue, 20 Jun 2023 10:04:37 -0700 In-Reply-To: <20230619215534.GA442477@nathanxps13> References: <20230113225626.GA2380176@nathanxps13> <20230113231339.GA2422750@nathanxps13> <20230613211246.GA219055@nathanxps13> <20230613235442.GA222795@nathanxps13> <20230614181711.GA488295@nathanxps13> <20230615041044.GA736001@nathanxps13> <20230615235700.GA877311@nathanxps13> <20230616052025.GA1026700@nathanxps13> <20230619215534.GA442477@nathanxps13> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2023-06-19 at 14:55 -0700, Nathan Bossart wrote: > In v4 of the patch set, I moved the skip_privs flag refactoring to > 0001.=C2=A0 I > intend to commit this tomorrow unless there is additional feedback. I think v4-0001 broke the handling of toast tables? It looks like you removed the check for !skip_privs but need to add it to the flags in vacuum_is_permitted_for_relation().=20 Regards, Jeff Davis