Date: Wed, 16 Jul 2025 16:22:31 +0900
From: Yugo Nagata <nagata@sraoss.co.jp>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Nathan Bossart
 <nathandbossart@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 <pgsql-hackers@postgresql.org>
Subject: Re: Extend ALTER DEFAULT PRIVILEGES for large objects
Message-Id: <20250716162231.c5d135012174959b7b482aa2@sraoss.co.jp>
In-Reply-To: <4e7a71b5-1c7e-48bf-909a-aee5a413fa97@oss.nttdata.com>
References: <20240424115242.236b499b2bed5b7a27f7a418@sraoss.co.jp>
	<20240913161801.b1e60534d77fa9df447b775f@sraoss.co.jp>
	<9c0c4d7881d2450baf70edb0ae95415a81ac8cb1.camel@cybertec.at>
	<20250123192220.9bad2b9aec110bf335521276@sraoss.co.jp>
	<fb552452-d61f-403b-85c1-187ea7f030af@oss.nttdata.com>
	<20250403230418.f41b23d155f6c6cb3cebcd92@sraoss.co.jp>
	<dfa9a1fc-1570-45a0-8735-57c414629cec@oss.nttdata.com>
	<ade0ab29-777f-47f6-9d0d-1af67728a86e@oss.nttdata.com>
	<20250408122857.b2b06dde4e6a08290af02336@sraoss.co.jp>
	<20250611114937.b067c542192f8e5e740a2a4a@sraoss.co.jp>
	<b448cc01-ce8d-45f3-a922-c63490bbdec4@oss.nttdata.com>
	<20250611135737.bb7d3135141248819704ebca@sraoss.co.jp>
	<a09986e3-958c-4151-8244-f43c28701ddf@oss.nttdata.com>
	<20250710103041.f93be994017e4ab61b9b9c35@sraoss.co.jp>
	<610c7506-3cd2-41c6-8346-581d120cf841@oss.nttdata.com>
	<20250710141129.94cb58f465e706fa37c1b9d2@sraoss.co.jp>
	<4e7a71b5-1c7e-48bf-909a-aee5a413fa97@oss.nttdata.com>
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?us-ascii?Q?WhxXJHkH15LHnlE+7NqTROb9wbQjUCPVaFRVOZT18QHVuGzVWQK7gschcv0/?=
 =?us-ascii?Q?HXMihOOBzWdpbonpmtxcNkF7Rs76TUC+M7ygWEsZrkzi/IjMk7G2v2i+GR/v?=
 =?us-ascii?Q?lFGJy49KPVuRRMrUj04n0OwDXti58djKVRyDtaFNIo3weII9rG417j0Ljh+U?=
 =?us-ascii?Q?+1dM4maPsGvM4lKIg8EPtNVgs8Gsxbbx2/Ko4hBoCy2pON6ykzbu2o54uPf2?=
 =?us-ascii?Q?79UM6MK2zWw1RgYfzY/xrRQYNpbHTtNo0r8IWVZp5biZleaZXyJZuHCl6yIB?=
 =?us-ascii?Q?50ZdWH0e3IOEzFiqjBldt1zoVmmoREOJtl6btEGZavlxQJ2agO9zdyQcN6CD?=
 =?us-ascii?Q?Q+EwWH1TuKXWK3LhygqxIFfZ45S0uqUrc80BQGJZZ8ChIJa6rosElvVU0tZx?=
 =?us-ascii?Q?3xx0+CHCNdebqyuDBGzB6cTn5sU8StNYzBmvTTaHqsN8DxbDjQe2GeiG1A/c?=
 =?us-ascii?Q?fotfD9X25V+kRajJfNPvYtTYnW01Udcb1HRsCH8eAlDLLj0sxPV2FSspOyVx?=
 =?us-ascii?Q?+rHPNoavXYi7f4G/2WQI9AlA6+hRvO+Ll67ZhE+6od/nChl7ha7GDRmTjYyW?=
 =?us-ascii?Q?Rd8lfZnzumFdccqTcNi+wK4fp2JsekuV8F9VDTCIEELe3Jce3yFHMTmqmc1u?=
 =?us-ascii?Q?yIOv7RQOQTMrDeP6xdPr/mZpE76q0vhQ+n+iyQtDwPh26ao9DPs84HJAMVoc?=
 =?us-ascii?Q?7gxyh5MwzbtLas06s+otgU5WeVKYWyWwyPgqFepHhBeoBdxqcZ+pJeNy5qUK?=
 =?us-ascii?Q?vb31yQpozCu6pm+mL+2VFEvMAfHpt4APj1AeimjYXq/4ApHa8xX3DMlrQfP1?=
 =?us-ascii?Q?OPOO/3EjX0tWZ85Ywg20BIlzR26c6T1e2UCPuqfy59zuD8m6uRpglSDvncYz?=
 =?us-ascii?Q?GELIDbniMLYeReW34W7SfRuioPcbgyL2Y2bmbONVSZPELqSOkovsTTwslcdn?=
 =?us-ascii?Q?7zalBrC6cWK2RQXCv6NU4vKsDxZNjLmV+UaNmDt3z1Eti+gIO4qAyBtT8w8L?=
 =?us-ascii?Q?uAcZ2nyOGuVKlLEpITNZfcdrASNCfnEd6blNiBlBliuc4CXVrXkmvNfbQIqy?=
 =?us-ascii?Q?IZTvn1wUM3ZJQ3m7Gv8S1CZCdZRlgsSYZ13/0QJqVuXJIf4tK3+Kux/7hxom?=
 =?us-ascii?Q?V/1dFHr0TAEHDsmd0UVbQFzp3p9TZofPssW5NnMfrpgYMA614QVs2tFG86QB?=
 =?us-ascii?Q?GcSYauAMjLzJiBhqGb6O+IPi2cBzbujHGUmrd0bWSELEt+DiE9A/8K2rbrCy?=
 =?us-ascii?Q?fqWnCnn5CWkqTJk9/SUy3hWHbG+zRsLb1MoVhYJfRU3Gzu4VIF8Vl2eqCmV8?=
 =?us-ascii?Q?NZu2CsQHWeEyR6lOvl78KlRYro4aya98kk3L+L2kyK8SIZF9m/okZkOTQflx?=
 =?us-ascii?Q?ZIXsDGeYPfy9WNPGVPbvFEo9ivhrp3okOg4GR7a6kzb7Ji/pwEMUyk3UOV1Q?=
 =?us-ascii?Q?3KFVRyZlyZvu/fwhKrgVHOVLUD60jgwB9R4UmwVRxH7PqoSkld+U1RruImd1?=
 =?us-ascii?Q?CSQMNnOHEhVYcwJ407OHNmik7Ze10e2QCMkVIDVNDQmo+/ud1QsVdDsSkEpZ?=
 =?us-ascii?Q?vaGtneqiqR6+GJqjfWOaaGJKZ7xpgsD5sEdMc1D+9u96CsSTGZFSL24INMMX?=
 =?us-ascii?Q?rqWEpmvekEeaQLgpFGfp6L9bdabXSIe/sZfTLkpDJwRp?=
X-OriginatorOrg: sraoss.co.jp
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 4960fa7a-416c-45e2-6599-08ddc439874f
X-MS-Exchange-CrossTenant-AuthSource: OSZP286MB2160.JPNP286.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 16 Jul 2025 07:22:31.9993
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 75db6c32-352e-4063-ae79-cafb8623f6db
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: 
 VNUIxx4sy2MgHVenOCEFiMjEkUW5sWu0E5XPeuGV76CA/xFVWWuW7OJoVwKfE6tMLvdHzjZq/UMcZwl8LQwQeg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4P286MB5409
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/20250716162231.c5d135012174959b7b482aa2%40sraoss.co.jp>
Precedence: bulk

On Tue, 15 Jul 2025 19:07:16 +0900
Fujii Masao <masao.fujii@oss.nttdata.com> wrote:

> I've pushed the patch. Thanks!

Thank you!

> 
> >>> But perhaps this corner case doesn't really
> >>> need to be handled?
> >>
> >> Probably I failed to get your point here. Could you clarify what you meant?
> > 
> > I'm sorry for not explaining it clearly.
> > 
> > Currently, TO or FROM could be suggested immediately after FOREIGN SERVER, but
> > only when no foreign servers are defined. When foreign servers do exist,
> > their names are correctly suggested instead, as expected.
> > 
> > The patch fixed the behavior so that TO or FROM are not suggested after FOREIGN SERVER,
> > even when no foreign servers are defined. However, I've started to wonder if it's worth
> > fixing such a corner case. What do you think?
> 
> I think it's worth doing. This issue can lead to unexpected behavior
> and is something users might run into. If the fix were overly complex
> for a minor issue, it might not be justified. But that's not the case here.

Thank you for your explanation.
It makes sense to me.

Regards,
Yugo Nagata

-- 
Yugo Nagata <nagata@sraoss.co.jp>