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 1ssunM-00BuXb-7x for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Sep 2024 01:56:52 +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 1ssunL-000aqc-8b for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Sep 2024 01:56:51 +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 1ssunK-000ami-W0 for pgsql-bugs@lists.postgresql.org; Tue, 24 Sep 2024 01:56:51 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssunI-000jYd-Fn for pgsql-bugs@lists.postgresql.org; Tue, 24 Sep 2024 01:56:49 +0000 Received: from phl-compute-09.internal (phl-compute-09.phl.internal [10.202.2.49]) by mailfout.phl.internal (Postfix) with ESMTP id D10F7138047E; Mon, 23 Sep 2024 21:56:46 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-09.internal (MEProxy); Mon, 23 Sep 2024 21:56:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1727143006; x=1727229406; bh=jD9wb9yMIR O4xqVUiZFpEXPgy3MoJptmz+gNpjsyz2U=; b=haudBMmCQ7eNnmW6EoE0NNUtHU Ak6WUFERc/TCl81XzCy3rDqS162EfryuybbVV3GB15eg1JnHC4xVlCswW00Wl2Y4 27oONNK+yi1GWUkZ89LpgYwvJJeaSAfmdF/N7fsVsi26L102P6Dk1LxqsBQtpz7G 6bUK+WuSs93WjrJmTZMf3fRS9G9WOPib06dP0Wer2mvvq49OfnLu82SYseSEZq9g rmTBabsC2sjsNWacI4rQT+hNA2geHNU62n4+leyQQEkHOMcZWLMp1hfQt3CMXmIW hh6PmwOjq6xfTsZQcre5ln/pkVkyMnGgSn5788Z8qcxTici3RQ38X6YJWeyw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1727143006; x=1727229406; bh=jD9wb9yMIRO4xqVUiZFpEXPgy3Mo Jptmz+gNpjsyz2U=; b=IcYXCa5zc/NztHicoOsTyXnj9z73kVZOiBrgWuHRLTSX uN3jwKVbXkxKXh49eU4tQpdKP2u/1/EUEie9MEc3NbgTPzKZsPauUAoaAMRNTI2p Yg4Skw/4V73r4NSqeD+PbURRh4KJbf8BOw/YamOZ8HXcxo7colOfua+o8oDd0as5 8WY0bVajrXQtfDQkDj4dmi5Z1gjGcyW1+Gs8mqs4iv0tFvU3j+fKKIofyXZO0giV 6yBGcUuu5bjLZ6vuGixdQQmKjeHXFWMbn75Yq8+ME39UWpP6oY7nSHtnbLiTUZJz Xi1vBFj85sOdKiNEZ0Xo0OsOK3ulbKkLCeu/kbaOZA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvddtuddgvdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteel ieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhes phgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohepkedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepphhoshhtghhrvghsvhgrihgshhgrvhgvsehgmhgrihhlrdgtohhm pdhrtghpthhtohepgihofhesthhhvggsuhhilhgurdgtohhmpdhrtghpthhtohepnhgrth hhrghnuggsohhsshgrrhhtsehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhglhesshhs shdrphhghhdrphgrrdhushdprhgtphhtthhopehmrghsrghordhfuhhjihhisehoshhsrd hnthhtuggrthgrrdgtohhmpdhrtghpthhtohepnhhorghhsehlvggruggsohgrthdrtgho mhdprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqh hlrdhorhhgpdhrtghpthhtohepvhhsvghkrghrsehmihgtrhhoshhofhhtrdgtohhm X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 23 Sep 2024 21:56:43 -0400 (EDT) Date: Tue, 24 Sep 2024 10:56:27 +0900 From: Michael Paquier To: vaibhave postgres Cc: Christophe Pettus , Nathan Bossart , Tom Lane , Fujii Masao , Noah Misch , PostgreSQL Bug List , vsekar@microsoft.com Subject: Re: vacuumdb: permission denied for schema "pg_temp_7" Message-ID: References: <20240920215030.8d.nmisch@google.com> <2603142.1726873660@sss.pgh.pa.us> <5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com> <2649165.1726898595@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="1ONovXgZWB+YMUj9" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --1ONovXgZWB+YMUj9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 24, 2024 at 07:05:41AM +0530, vaibhave postgres wrote: > Looks like Michael has already sent the updated patch from the discussions > in this thread so far. Let me know if anything else needs to be done. Yes, the timing of your reply was interesting ;) The temporary persistence issue is one side of the coin, and that's the only part I have sent now as there is also a performance argument (while being entirely useless to do). The permission parts with USAGE and MAINTAIN need a bit more thoughts. -- Michael --1ONovXgZWB+YMUj9 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmbyHEsACgkQnvQgOdby QH2zeg/+KgaoKV3kfupcQRvrlYJnuT8EdYrRppmNTHwoWHHyWtnAnCpzrlg5Miut O8SD4xiUaiiWa94mWHKFf+WLDXR3JzFRVfo9gfMIIFV2I8gl0XYNIItOhC4AGCda rHnUhDLZUsD0c57INgN5HDt6jOVxQZyczWHdeFO2cwWrBR9L+zLLwKTson7DnXbs xKxIGxPlmtr0SyYJGD9+UWANwwwGrC1ZdzIB2yIbSgz5deCFlV/pCvUapA7w2Grr bRwib8bK4yGJO7wEA9Fpv/i/pz9v4ZwABWyt9fO9cXnLC6eGpFCceyPcGz70tj+9 wgW1h+tXfDa9wEi8aVP5N8gTgMcYxT0hQ3E8u2yT20lbNsHOKmoxoylGZ64BRyU0 bAvUxftt1ZJpY+cmXcwPX2y9Jybkq/sKIQgIUAtPbJrAQBycDA9JLg/9R273q/fT 93Nafzal9gaTTPxZ9W/kJRqq5acdfc+MPKi+9KbUNlHfUp0NakD3nO4sBRb70cey VujuJjT+bSHgeVcm5mWM+flqHJFG1I6oUskgXcIKmEsEh/ogU2SULvQL+K8By7Ft SkRbsRNJalcBKzBFIrUnSTAgP9byFjeAndew3Lp3D+jO/cBJoZXEKAsU6YFvtp6C 7kkrkXHUx0MwiRJtQOOpSti0FJvEFLk0z5IqiozG7HcLlEL8QgY= =ta2K -----END PGP SIGNATURE----- --1ONovXgZWB+YMUj9--