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 1ssnkC-00B1GU-3O for pgsql-bugs@arkaria.postgresql.org; Mon, 23 Sep 2024 18:25:08 +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 1ssnkA-00DDn8-3Z for pgsql-bugs@arkaria.postgresql.org; Mon, 23 Sep 2024 18:25:06 +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 1ssnk9-00DDmC-R9 for pgsql-bugs@lists.postgresql.org; Mon, 23 Sep 2024 18:25:05 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ssnk7-000gaM-H9 for pgsql-bugs@lists.postgresql.org; Mon, 23 Sep 2024 18:25:04 +0000 Received: by mail-io1-xd2f.google.com with SMTP id ca18e2360f4ac-82a626d73efso175523839f.1 for ; Mon, 23 Sep 2024 11:25:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727115902; x=1727720702; darn=lists.postgresql.org; 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=9PURICw4tUc3j2jT2IQFWfY1DfYcBxi9rYjXIwRYEN8=; b=PV//pKV0xszQIWvEbIaFXn3kBQEyyR7wk3w+mXCwLXxhU6OJxVUKv57ykZ2PfGdcQW rUXttglDZyWZGHoze6VdJ4nPBe7XEiJGqWNjG+FxtYf8l0j4QCJ8EBm12jlfbPqHbpJk cFnsj8hJs5EopEW1oBy+hA6LB4oHdObopNhQ3tKR0mN5SvNdX1GaHntGmLO/SJ7ycF82 iCAfTudhxWlyD6IoCZIiW+XJskxZYzqQZcPvhc/6+pu9XnA+9nF4HOdWFab+yyzAgy8w j/+rTOTEQTH3qo/njGKWzTIOUWR3WfwtynjrOeQ352mrPLlModF6T0AELXuLZuoJf0LV ayPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727115902; x=1727720702; 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=9PURICw4tUc3j2jT2IQFWfY1DfYcBxi9rYjXIwRYEN8=; b=I4vJtSVx0zFXEbwyxnEiSNeaqxlervM7POtNfhjixSNRhQEJXQG3rsLTtpgk5Fg+pU FY9mDN4kc0Js/fLC2/LFmDdPf1Wh9Jx6JgkZAJn380kJ0+0WZEq+whUcFBndTEg4xwn+ 10vj6GZpw9kbuwhzoYpQdKpjtzYlcQPjnic7sv8O97KmFt2rgN/DpyQSTJ6j8sowwnAa fprq9DTL4GJhfMyPkRgFLglZDmNDz/lP0USlrGemyWxZWPafGAGPdWbHA+XKK7HeMnAd QwaIc4KGosWwsYx+ZOK2/7AvNIfty8JSdc/ibhNTbilgUSc+ZyZwo05tK2K3H7o1j6eM nPxA== X-Forwarded-Encrypted: i=1; AJvYcCUwGtqXwvu+8TzYrYzlqBug2AN3AieNtp64inRX5VmtBpLCMLvaamQMslZx+FLpm0TADsFtWY80pwPw@lists.postgresql.org X-Gm-Message-State: AOJu0YxovocOPhLnTHHw+u31lMzYZddZ//IbyC54Xyp3e3zXTXJmz0ie l5aAkee52qgWHt8mJ+/oNhh27PG9MWMI23XsXIMa0g7eeXsgg7OA X-Google-Smtp-Source: AGHT+IGGmvMmDX6FqKiUn6gi/qR6q1nNWHwFisI/h5kf2nWL5dBVWfDwwI34OnEc7sfzw7my8M5J9w== X-Received: by 2002:a05:6602:154b:b0:805:3d47:19d6 with SMTP id ca18e2360f4ac-8320b280526mr941914839f.6.1727115902350; Mon, 23 Sep 2024 11:25:02 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4d37ec17fb2sm5303466173.43.2024.09.23.11.25.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 23 Sep 2024 11:25:01 -0700 (PDT) Date: Mon, 23 Sep 2024 13:24:59 -0500 From: Nathan Bossart To: vaibhave postgres Cc: Tom Lane , Fujii Masao , Noah Misch , pgsql-bugs@lists.postgresql.org, vsekar@microsoft.com Subject: Re: vacuumdb: permission denied for schema "pg_temp_7" Message-ID: References: <20240920190731.37.nmisch@google.com> <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: 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 Sat, Sep 21, 2024 at 11:42:19AM +0530, vaibhave postgres wrote: > Thanks for the review and feedback. Are you planning to submit an updated patch? I don't think there's a tremendous amount of urgency to fix this since it's been broken for so long, but it'd be good to know whether someone is planning to pick it up. -- nathan