Message-ID: <bfbcf235ee774ab4b6225dfba7be25a60ac01808.camel@j-davis.com>
Subject: Re: MAINTAIN privilege -- what do we need to un-revert it?
From: Jeff Davis <pgsql@j-davis.com>
To: Nathan Bossart <nathandbossart@gmail.com>, Yugo NAGATA
 <nagata@sraoss.co.jp>
Cc: Noah Misch <noah@leadboat.com>, Michael Paquier <michael@paquier.xyz>,
	pgsql-hackers@postgresql.org, Joe Conway <mail@joeconway.com>, Robert Haas
	 <robertmhaas@gmail.com>
Date: Fri, 27 Sep 2024 09:22:48 -0700
In-Reply-To: <ZvbQknlG7dG21EUE@nathan>
References: <8e0438821bddd4de198989e6ac0f9a2aa27cabeb.camel@j-davis.com>
	 <20240713214748.cb@rfd.leadboat.com.sranhm>
	 <20240726122630.70e889f63a4d7e26f8549de8@sraoss.co.jp>
	 <a7ce2ffa94cb26e40acf0ed8de857425f4d74727.camel@j-davis.com>
	 <20240731182012.45d8231608896732395fc81a@sraoss.co.jp>
	 <6bf8a76ebf3215d2226dbc2245d351aae577e4c1.camel@j-davis.com>
	 <20240802161301.d975daca9ba7a706fa05ecd7@sraoss.co.jp>
	 <20240805160502.d2a4975802a832b1e04afb80@sraoss.co.jp>
	 <ZvXTErNZY-4HizMM@nathan>
	 <20240927124234.c5c18d6448c98b52fad62834@sraoss.co.jp>
	 <ZvbQknlG7dG21EUE@nathan>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu2 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/bfbcf235ee774ab4b6225dfba7be25a60ac01808.camel%40j-davis.com>
Precedence: bulk

On Fri, 2024-09-27 at 10:34 -0500, Nathan Bossart wrote:
> On Fri, Sep 27, 2024 at 12:42:34PM +0900, Yugo NAGATA wrote:
> > I agree with you. I overlooked WITH NO DATA.
> > I attached a updated patch.
>=20
> Thanks.=C2=A0 Unless someone objects, I plan to commit this shortly.

The command is run effectively in two parts: the CREATE part and the
REFRESH part. The former just uses the session search path, while the
latter uses the safe search path.

I suggest that we add the wording to the
<replaceable>query</replaceable> portion of the doc, near "security-
restricted operation".

Regards,
	Jeff Davis