Date: Wed, 11 Jun 2025 14:03:01 +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: <20250611140301.56e27e4a9f7406cc7b182437@sraoss.co.jp>
In-Reply-To: <b448cc01-ce8d-45f3-a922-c63490bbdec4@oss.nttdata.com>
References: <20240424115242.236b499b2bed5b7a27f7a418@sraoss.co.jp>
	<3602391.1713930458@sss.pgh.pa.us>
	<20240424210839.GA863220@nathanxps13>
	<20240426175406.13e47ea3904de814afbfe496@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>
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?xr1+ERQ0luCTYLKn6e0mYDIP1e9uwqv354kGzMTTj4CajbT0/z18Z4TWz1Ww?=
 =?us-ascii?Q?tHnS1uyX6VAqVAUBO2IiE6lDvI8E76RWBARIVTyzbR0Jnrfc0wsa3db0A7Pm?=
 =?us-ascii?Q?Wpm4AQg1g+Wma4z8zMR0LVSKMhhOw1pVpdaoO53OZDoIWLnWgR899uRVuqxw?=
 =?us-ascii?Q?WgwHSNFE24McgzAR8O5wbsifyvhJr+kFohkqiYE45OGcpY0myy4WBKJ788+y?=
 =?us-ascii?Q?wTX7EeDUrgq8Q7ho65u+7jj2wKvWox5LduBhGCmc0CZRSy/qLAB4FhV8i2wy?=
 =?us-ascii?Q?B8bsRccKe28sdw2NNngNFly5Hhzy6mVvtqMOhKWBYH//g49W2+cd4lLflnbZ?=
 =?us-ascii?Q?ExJheai8BiMgCzC6rquwfptfkP+ZDlSq0lXWLHB263uZ0UtvjE4LjDbWf8aR?=
 =?us-ascii?Q?HjvfzBF6VXBJwRvjgZoUR2TDgGkT8Q7NBC/uPuMwemZmWCNKPlmtM+UT4WGA?=
 =?us-ascii?Q?ryt/GwVOsRxWRtJNcbgGgR1L0ZOazZcHNa5kTqGjg/9RByOzB4Sk7Gl0AvJd?=
 =?us-ascii?Q?sdSrJkTCfdZ0ttNYWotgAyoNtYm1n4h68J0Jd/bqgc2ozMJkf6V4C1NxMnRl?=
 =?us-ascii?Q?lHdwDleM6fikzlYTj8gpAEc7ga5O2XNRNLtkp1T7fxyPF9mPcsIoVoVlW0yG?=
 =?us-ascii?Q?Oo0iMi+1lL7oXPlcPUHvSAQXV/vLcZ74XXme3mEo599l/R6EOorX3oepbyGD?=
 =?us-ascii?Q?aBXN5nSf1lPiVwSVBLsrw2JhWHEU97NChQEYdPeAkMOOl+IIhPODtV2T79Hc?=
 =?us-ascii?Q?OpSCFHT0o3JqXgktGdovWA14V8nnX3ySCzjxT2OwHu3SrhNwouKxj3xTUOod?=
 =?us-ascii?Q?mPf3a2LDHpypmX353pR5ur+v74sXTQI9ILjcFoiBL/DuLvpHsyy9Bsqfb4+B?=
 =?us-ascii?Q?T7/sjx5/K5z0x4VxlL0g/PDwj5dM+XFpmnmzsKj1GR2R0WWgGZynFfJVAR0E?=
 =?us-ascii?Q?4lGZqI15bTui0+UOqt8vwqX5sIAvPfqoEbw+eXJaMomoE3Lr/i6sAdH9dhex?=
 =?us-ascii?Q?+k4uWlWYRmEYQ2E20SMG33XLTzinmfaYFoCrXYU1RLcLe5Lz30c5+tDs8dvb?=
 =?us-ascii?Q?sB0GCQcvGr6i8iIenHr1up9kLdrfkegX8mhy3o/Ur+Ptfl+Qlx5OOUeagmWF?=
 =?us-ascii?Q?IxbZhvn/CQmzSfQ0Ts6gh6mFpkLN8N33MWWlAP9he93o8Bn9pEPK2K+9G9ZM?=
 =?us-ascii?Q?D+GsG4r2d2i+lZhG46JI753QOniKraeuUPWq4YmPutQLs2cAT9J4N0YqGDZH?=
 =?us-ascii?Q?2QUCuuGvlxZe/X3FNxqaMM1XMg5sNgVv4QsYSzJM5tpmu/fVhgX9e47UatwB?=
 =?us-ascii?Q?og3GZryANOcCasAcOAroh8CV8oZL7gyqU1z6CQzN9gSPKe1HEIilyo4vf6q0?=
 =?us-ascii?Q?eGd6fCVUQE3BjVJyHRwVCnd0LoOacg8VETNzPFzurAyaL8a5wrKgljdn6oMc?=
 =?us-ascii?Q?ewaCsabustUtpWnPZJl3qL7wwReT8ySnhFPEW1+/B8dtX6S0DD4WGlpBkBuN?=
 =?us-ascii?Q?CTw89zz6EW6TXnrI4A4CbViom5+DZsD7tbdJgaLrp/whPjz+XmFMb3qDRUfG?=
 =?us-ascii?Q?SZu2e5gsIJUNLH1OmCFAd25YIF6EFaDSRgaP96/3?=
X-OriginatorOrg: sraoss.co.jp
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 f1a620b9-b6f3-4c9d-06e3-08dda8a53e07
X-MS-Exchange-CrossTenant-AuthSource: OSZP286MB2160.JPNP286.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 11 Jun 2025 05:03:02.1282
 (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: 
 IQwIfwofKKZH1YzEhQey4jW/thyEk2FJQim5LFRRMt/CcCvYNIISy55pAdmmg8TPOOcvPyGM6XIZqqkPmsu+ww==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCP286MB3750
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/20250611140301.56e27e4a9f7406cc7b182437%40sraoss.co.jp>
Precedence: bulk

On Wed, 11 Jun 2025 13:33:07 +0900
Fujii Masao <masao.fujii@oss.nttdata.com> wrote:

> 
> 
> On 2025/06/11 11:49, Yugo Nagata wrote:
> > While looking at the thread [1], I've remembered this thread.
> > The patches in this thread are partially v18-related, but include
> > enhancement or fixes for existing feature, so should they be postponed
> > to v19, or should be separated properly to v18 part and other?
> > 
> > [1] https://www.postgresql.org/message-id/70372bdd-4399-4d5b-ab4f-6d4487a4911a%40oss.nttdata.com
> 
> I see these patches more as enhancements to psql tab-completion,
> rather than fixes for clear oversights in the original commit.
> 
> For example, if tab-completion for ALTER DEFAULT PRIVILEGES had
> completely missed LARGE OBJECTS, that would be an obvious oversight.
> But these patches go beyond that kind of issue.

Thank you for your clarification. I agreed.

Best regards,
Yugo Nagata

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