diff options
| author | Álvaro Herrera <alvherre@kurilemu.de> | 2025-05-11 10:16:45 -0400 |
|---|---|---|
| committer | Álvaro Herrera <alvherre@kurilemu.de> | 2025-05-11 10:16:45 -0400 |
| commit | dbf42b84ac7b4e1dfd1ac6e618e247100b6aa08b (patch) | |
| tree | e457fd9c59d70b4b93173d77b6402018cb30d192 | |
| parent | 0588656366687887d06b0b1f79c9adc142ea1595 (diff) | |
| download | postgresql-dbf42b84ac7b4e1dfd1ac6e618e247100b6aa08b.tar.gz postgresql-dbf42b84ac7b4e1dfd1ac6e618e247100b6aa08b.zip | |
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
| -rw-r--r-- | src/bin/psql/tab-complete.in.c | 6 |
1 files changed, 6 insertions, 0 deletions
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"); |