Re: Extend ALTER DEFAULT PRIVILEGES for large objects - Mailing list pgsql-hackers

From Yugo NAGATA
Subject Re: Extend ALTER DEFAULT PRIVILEGES for large objects
Date
Msg-id 20250408122857.b2b06dde4e6a08290af02336@sraoss.co.jp
Whole thread Raw
In response to Re: Extend ALTER DEFAULT PRIVILEGES for large objects  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
On Fri, 4 Apr 2025 19:18:11 +0900
Fujii Masao <masao.fujii@oss.nttdata.com> wrote:

> 
> 
> On 2025/04/04 0:21, Fujii Masao wrote:
> > Thanks for updating the patch!
> > 
> > If there are no objections, I'll proceed with committing it using the following commit log.
> 
> I've pushed the patch. Thanks!

Thank you!

 
> While testing the feature, I noticed that psql doesn't complete
> "ALTER DEFAULT PRIVILEGES GRANT/REVOKE ... ON LARGE OBJECTS" or
> "GRANT/REVOKE ... ON LARGE OBJECT ..." with TO/FROM. The attached
> patch adds tab-completion support for both cases.

This patch looks good to me. This works as expected.

While looking into this patch, I found that the tab completion suggests
TO/FROM even after "LARGE OBJECT", but it is not correct because
there should be largeobject id at that place. This is same for the
"FOREIGN SERVER", server names should be suggested ratar than TO/FROM
in this case. 

The additional patch 0002 fixed to prevents to suggest TO or FROM right
after LARGE OBJECT or FOREIGN SERVER. Also, it allows to suggest list of
foreign server names after FOREIGN SERVER.

The 0001 patch is the same you proposed.

Regards,
Yugo Nagata

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

Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [PATCH] clarify palloc comment on quote_literal_cstr
Next
From: Andres Freund
Date:
Subject: pg_dump/restore failure (dependency?) on BF serinus