diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2001-05-08 21:06:43 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2001-05-08 21:06:43 +0000 |
| commit | 1c1c58c76cc53b56da24d0d87365acfdd84e325d (patch) | |
| tree | 11ed52e106b089a2d75ed256353b3056aff4a244 /src/bin/psql/tab-complete.c | |
| parent | c50aa9db70b817ee1b982ec0795ed2c81f9ef667 (diff) | |
| download | postgresql-1c1c58c76cc53b56da24d0d87365acfdd84e325d.tar.gz postgresql-1c1c58c76cc53b56da24d0d87365acfdd84e325d.zip | |
Add SET SESSION AUTHORIZATION command.
Diffstat (limited to 'src/bin/psql/tab-complete.c')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 20 |
1 files changed, 18 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index ce2a6692b77..dd323162dda 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -3,7 +3,7 @@ * * Copyright 2000 by PostgreSQL Global Development Group * - * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.31 2001/05/07 19:31:33 petere Exp $ + * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.32 2001/05/08 21:06:43 petere Exp $ */ /*---------------------------------------------------------------------- @@ -201,7 +201,7 @@ psql_completion(char *text, int start, int end) /* these SET arguments are known in gram.y */ "CONSTRAINTS", "NAMES", - "SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL", + "SESSION", "TRANSACTION ISOLATION LEVEL", /* these are treated in backend/commands/variable.c */ "DateStyle", @@ -646,6 +646,22 @@ psql_completion(char *text, int start, int end) COMPLETE_WITH_LIST(constraint_list); } + /* Complete SET SESSION with AUTHORIZATION or CHARACTERISTICS... */ + else if (strcasecmp(prev2_wd, "SET") == 0 && strcasecmp(prev_wd, "SESSION") == 0) + { + char *my_list[] = {"AUTHORIZATION", + "CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL", + NULL}; + + COMPLETE_WITH_LIST(my_list); + } + /* Complete SET SESSION AUTHORIZATION with username */ + else if (strcasecmp(prev3_wd, "SET") == 0 + && strcasecmp(prev2_wd, "SESSION") == 0 + && strcasecmp(prev_wd, "AUTHORIZATION") == 0) + { + COMPLETE_WITH_QUERY(Query_for_list_of_users); + } /* Complete SET <var> with "TO" */ else if (strcasecmp(prev2_wd, "SET") == 0 && strcasecmp(prev4_wd, "UPDATE") != 0) |