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-04-27 09:02:32
Message-ID: c74a62e5-ac51-4bb6-a921-119c61496b20@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-04-27 09:38:06 Re: Proposal: Conflict log history table for Logical Replication
Previous Message Nisha Moond 2026-04-27 09:02:04 Re: Support EXCEPT for TABLES IN SCHEMA publications