Horton
Menu

Thread

Commits

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

  1. Add psql tab completion for FOR PORTION OF clause

  1. Add psql tab completion support for FOR PORTION OF

    Kiran K <itskkpg@gmail.com> — 2026-04-15T03:52:36Z

    Hi Hackers,

Add tab completion support in psql for the FOR PORTION OF clause
used in UPDATE and DELETE statements with temporal tables.
Attached a patch with the changes and corresponding tests.


Regards,
Kiran

  2. Re: Add psql tab completion support for FOR PORTION OF

    Peter Eisentraut <peter@eisentraut.org> — 2026-04-27T09:02:32Z

    On 15.04.26 05:52, Kiran K wrote:
> Add tab completion support in psql for the FOR PORTION OF clause
> used in UPDATE and DELETE statements with temporal tables.
> Attached a patch with the changes and corresponding tests.

This looks very useful, but it seems one of the rules doesn't quite work 
in my testing:

update pg_class for portion of oid from 1 to 2 <tab>

I think you mean for this to complete AS or SET, but it offers nothing 
in my testing.  (Same with DELETE.)

(Obviously, the table and column names and values are nonsense, but they 
should work for the purpose of tab completion.)

  3. Re: Add psql tab completion support for FOR PORTION OF

    Peter Eisentraut <peter@eisentraut.org> — 2026-05-12T15:30:22Z

    On 27.04.26 11:02, Peter Eisentraut wrote:
> On 15.04.26 05:52, Kiran K wrote:
>> Add tab completion support in psql for the FOR PORTION OF clause
>> used in UPDATE and DELETE statements with temporal tables.
>> Attached a patch with the changes and corresponding tests.
> 
> This looks very useful, but it seems one of the rules doesn't quite work 
> in my testing:
> 
> update pg_class for portion of oid from 1 to 2 <tab>
> 
> I think you mean for this to complete AS or SET, but it offers nothing 
> in my testing.  (Same with DELETE.)

In order to semi-conclude this thread, I have committed this patch with 
the rule that didn't work removed.  Thanks.

  4. Re: Add psql tab completion support for FOR PORTION OF

    Kiran K <itskkpg@gmail.com> — 2026-05-15T05:08:13Z

    @Peter,

Thanks so much for fixing and pushing that, really appreciate it! Your
feedback sparked a few more scenarios I want to explore. Planning to get
those changes out early next week.

On Tue, May 12, 2026 at 8:30 AM Peter Eisentraut <peter@eisentraut.org>
wrote:

> On 27.04.26 11:02, Peter Eisentraut wrote:
> > On 15.04.26 05:52, Kiran K wrote:
> >> Add tab completion support in psql for the FOR PORTION OF clause
> >> used in UPDATE and DELETE statements with temporal tables.
> >> Attached a patch with the changes and corresponding tests.
> >
> > This looks very useful, but it seems one of the rules doesn't quite work
> > in my testing:
> >
> > update pg_class for portion of oid from 1 to 2 <tab>
> >
> > I think you mean for this to complete AS or SET, but it offers nothing
> > in my testing.  (Same with DELETE.)
>
> In order to semi-conclude this thread, I have committed this patch with
> the rule that didn't work removed.  Thanks.
>
>