Re: TAB completion for ALTER TABLE ... ALTER CONSTRAINT ... ENFORCED - Mailing list pgsql-hackers

> On 11 Aug 2025, at 18:20, Kirill Reshke <reshkekirill@gmail.com> wrote:
>
> Hi hackers!
>
> While looking at [0] I noticed that  current psql tab-complete lacks support for
>
> ALTER TABLE ... ALTER CONSTRAINT ... [NOT] ENFORCED and
>
> ALTER TABLE ... ALTER CONSTRAINT ... [NO] INHERIT
>
> patterns.

Hi!

> COMPLETE_WITH("ENFORCED", "NOT ENFORCED", "NO INHERIT", "INHERIT");

According to gram.y there might be DEFERRABLE and NOT DEFERRABLE, INITIALLY IMMEDIATE and INITIALLY DEFERRED (NOT VALID
isacceptable by rules but not by the action) 

Maybe we can add them too? If so, i attached v2 patch with this options added.

--
Best regards,
Roman Khapov