From dbf42b84ac7b4e1dfd1ac6e618e247100b6aa08b Mon Sep 17 00:00:00 2001 From: =?utf8?q?=C3=81lvaro=20Herrera?= Date: Sun, 11 May 2025 10:16:45 -0400 Subject: [PATCH] Add tab-complete for ALTER DOMAIN ADD [CONSTRAINT] MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit We can add tab-completion with "CHECK (" and "NOT NULL" after ALTER DOMAIN ADD [CONSTRAINT]. ALTER DOMAIN dom ADD -> CHECK ( ALTER DOMAIN dom ADD -> NOT NULL ALTER DOMAIN dom ADD -> CONSTRAINT ALTER DOMAIN dom ADD CONSTRAINT nm -> CHECK ( ALTER DOMAIN dom ADD CONSTRAINT nm -> NOT NULL Author: jian he Author: Dagfinn Ilmari Mannsåker Discussion: https://postgr.es/m/CACJufxG_f6LzAT_McC-kKmQWpuWnOYKyNBw8Kv3xzTjPqmeHcA@mail.gmail.com --- src/bin/psql/tab-complete.in.c | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c index c916b9299a8..ec65ab79fec 100644 --- a/src/bin/psql/tab-complete.in.c +++ b/src/bin/psql/tab-complete.in.c @@ -2539,6 +2539,12 @@ match_previous_words(int pattern_id, else if (Matches("ALTER", "DOMAIN", MatchAny)) COMPLETE_WITH("ADD", "DROP", "OWNER TO", "RENAME", "SET", "VALIDATE CONSTRAINT"); + /* ALTER DOMAIN ADD */ + else if (Matches("ALTER", "DOMAIN", MatchAny, "ADD")) + COMPLETE_WITH("CONSTRAINT", "NOT NULL", "CHECK ("); + /* ALTER DOMAIN ADD CONSTRAINT */ + else if (Matches("ALTER", "DOMAIN", MatchAny, "ADD", "CONSTRAINT", MatchAny)) + COMPLETE_WITH("NOT NULL", "CHECK ("); /* ALTER DOMAIN DROP */ else if (Matches("ALTER", "DOMAIN", MatchAny, "DROP")) COMPLETE_WITH("CONSTRAINT", "DEFAULT", "NOT NULL"); -- 2.30.2