Re: Add psql tab completion support for FOR PORTION OF

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Kiran K <itskkpg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add psql tab completion support for FOR PORTION OF
Date: 2026-05-12 15:30:22
Message-ID: b993803c-f518-4187-8ae6-52e47edcf4dd@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2026-05-12 15:37:47 Re: FOR PORTION OF vs. object_aclcheck
Previous Message Melanie Plageman 2026-05-12 14:57:57 Re: First draft of PG 19 release notes