> On 11 Aug 2025, at 18:20, Kirill Reshke <[email protected]> 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

Attachment: v2-0001-Add-tab-completion-for-ALTER-TABLE-xxx-ALTER-CONT.patch
Description: Binary data


Reply via email to