Re: Tab completion for large objects

Fujii Masao <masao.fujii@oss.nttdata.com>

From: Fujii Masao <masao.fujii@oss.nttdata.com>

To: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>, pgsql-hackers@lists.postgresql.org

Date: 2025-07-09T10:45:56Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Improve tab completion for large objects.
- 14ee8e640300 19 (unreleased) landed


On 2025/07/09 3:50, Dagfinn Ilmari Mannsåker wrote:
> Hi hackers,
> 
> I noticed that psql's tab completion suggested TO immediately after
> GRANT ... ON LARGE OBJECT, and not after ON LARGE OBJECT <oid>.  This is
> because LARGE OBJECT is the only two-word object type, so it thinks
> LARGE is the object type and OBJECT is the name.  Attached are three
> patches that address this and other LO-related tab completion issues:
> 
>   1. Tab complete OBJECT after GRANT|REVOKE ... ON LARGE, and TO/FROM
>      after GRANT|REVOKE ... ON LARGE OBJECT

Thanks for the patches!

Regarding the 0001 patch, Nagata-san already proposed a similar patch in [1].
His version handles not only "LARGE OBJECT" but also another two-word object type,
"FOREIGN SERVER".

Regards,

[1] https://postgr.es/m/20250611135737.bb7d3135141248819704ebca@sraoss.co.jp

-- 
Fujii Masao
NTT DATA Japan Corporation