postgres.git / summary / log / commit / refs

commit    dbf42b84ac7b4e1dfd1ac6e618e247100b6aa08b
Author:   Álvaro Herrera <alvherre@kurilemu.de>
Date:     Sun May 11 14:16:45 2025 +0000
First released in: 18.0

    Add tab-complete for ALTER DOMAIN ADD  [CONSTRAINT]
    
    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 <jian.universality@gmail.com>
    Author: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
    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 <sth> ADD */
+	else if (Matches("ALTER", "DOMAIN", MatchAny, "ADD"))
+		COMPLETE_WITH("CONSTRAINT", "NOT NULL", "CHECK (");
+	/* ALTER DOMAIN <sth> ADD CONSTRAINT <sth> */
+	else if (Matches("ALTER", "DOMAIN", MatchAny, "ADD", "CONSTRAINT", MatchAny))
+		COMPLETE_WITH("NOT NULL", "CHECK (");
 	/* ALTER DOMAIN <sth> DROP */
 	else if (Matches("ALTER", "DOMAIN", MatchAny, "DROP"))
 		COMPLETE_WITH("CONSTRAINT", "DEFAULT", "NOT NULL");


[parent: 058865636668]