diff options
| -rw-r--r-- | src/backend/commands/user.c | 4 | ||||
| -rw-r--r-- | src/bin/psql/sql_help.h | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/backend/commands/user.c b/src/backend/commands/user.c index 044779b7ee2..2360cc3bb80 100644 --- a/src/backend/commands/user.c +++ b/src/backend/commands/user.c @@ -5,7 +5,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: user.c,v 1.39 1999/11/30 03:57:23 momjian Exp $ + * $Id: user.c,v 1.40 1999/11/30 04:29:56 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -282,7 +282,7 @@ AlterUser(AlterUserStmt *stmt, CommandDest dest) } /* look for duplicate sysid */ - tuple = SearchSysCacheTuple(USESYSID, + tuple = SearchSysCacheTuple(SHADOWSYSID, Int32GetDatum(stmt->sysid), 0, 0, 0); if (HeapTupleIsValid(tuple)) diff --git a/src/bin/psql/sql_help.h b/src/bin/psql/sql_help.h index 65ca26fd36f..520f1a29f45 100644 --- a/src/bin/psql/sql_help.h +++ b/src/bin/psql/sql_help.h @@ -24,7 +24,7 @@ static struct _helpStruct QL_HELP[] = { { "ALTER USER", "Modifies user account information", - "ALTER USER username [ WITH PASSWORD password ]\n [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]\n [ IN GROUP groupname [, ...] ]\n [ VALID UNTIL 'abstime' ]" }, + "ALTER USER username\n [ WITH\n [ SYSID uid ]\n [ PASSWORD password ] ]\n [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]\n [ IN GROUP groupname [, ...] ]\n [ VALID UNTIL 'abstime' ]" }, { "BEGIN", "Begins a transaction in chained mode", @@ -100,7 +100,7 @@ static struct _helpStruct QL_HELP[] = { { "CREATE USER", "Creates account information for a new user", - "CREATE USER username\n [ WITH PASSWORD password ]\n [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]\n [ IN GROUP groupname [, ...] ]\n [ VALID UNTIL 'abstime' ]" }, + "CREATE USER username\n [ WITH\n [ SYSID uid ]\n [ PASSWORD password ] ]\n [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]\n [ IN GROUP groupname [, ...] ]\n [ VALID UNTIL 'abstime' ]" }, { "CREATE VIEW", "Constructs a virtual table", |