* User management commands no longer user pg_exec_query_dest -> more robust
Peter Eisentraut <peter_e@gmx.net>
* User management commands no longer user pg_exec_query_dest -> more robust * Let unprivileged users change their own passwords. * The password is now an Sconst in the parser, which better reflects its text datatype and also forces users to quote them. * If your password is NULL you won't be written to the password file, meaning you can't connect until you have a password set up (if you use password authentication). * When you drop a user that owns a database you get an error. The database is not gone.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/Makefile | modified | +6 −4 |
| doc/src/sgml/ref/allfiles.sgml | modified | +4 −1 |
| doc/src/sgml/ref/alter_group.sgml | added | +162 −0 |
| doc/src/sgml/ref/alter_user.sgml | modified | +36 −75 |
| doc/src/sgml/ref/commands.sgml | modified | +4 −1 |
| doc/src/sgml/ref/create_group.sgml | added | +176 −0 |
| doc/src/sgml/ref/create_user.sgml | modified | +39 −98 |
| doc/src/sgml/ref/drop_group.sgml | added | +138 −0 |
| doc/src/sgml/ref/drop_user.sgml | modified | +33 −32 |
| src/backend/commands/copy.c | modified | +9 −12 |
| src/backend/commands/user.c | modified | +475 −460 |
| src/backend/parser/gram.y | modified | +32 −62 |
| src/backend/tcop/utility.c | modified | +8 −12 |
| src/backend/utils/misc/superuser.c | modified | +3 −4 |
| src/bin/scripts/createuser | modified | +2 −2 |
| src/include/commands/copy.h | modified | +2 −2 |
| src/include/commands/user.h | modified | +7 −7 |
| src/include/nodes/parsenodes.h | modified | +14 −6 |