Re: TAB completion for ALTER TABLE ... ALTER CONSTRAINT ... ENFORCED

> On 11 Aug 2025, at 18:20, Kirill Reshke <reshkekirill(at)gmail(dot)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 is acceptable 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