]> granicus.if.org Git - postgresql/commit
Reserve the "pg_" namespace for roles
authorStephen Frost <sfrost@snowman.net>
Fri, 8 Apr 2016 20:56:27 +0000 (16:56 -0400)
committerStephen Frost <sfrost@snowman.net>
Fri, 8 Apr 2016 20:56:27 +0000 (16:56 -0400)
commit293007898d3fa5a815c1c5814df53627553f114d
tree462f41b12ee37a4f0de5b6707bd49b734cb24668
parentfa6075e5515c6878b2c1fe1c6435dd7ed847857d
Reserve the "pg_" namespace for roles

This will prevent users from creating roles which begin with "pg_" and
will check for those roles before allowing an upgrade using pg_upgrade.

This will allow for default roles to be provided at initdb time.

Reviews by José Luis Tallón and Robert Haas
21 files changed:
doc/src/sgml/ref/psql-ref.sgml
src/backend/catalog/aclchk.c
src/backend/catalog/catalog.c
src/backend/commands/alter.c
src/backend/commands/foreigncmds.c
src/backend/commands/policy.c
src/backend/commands/schemacmds.c
src/backend/commands/tablecmds.c
src/backend/commands/tablespace.c
src/backend/commands/user.c
src/backend/commands/variable.c
src/backend/utils/adt/acl.c
src/bin/pg_dump/pg_dumpall.c
src/bin/pg_upgrade/check.c
src/bin/psql/command.c
src/bin/psql/describe.c
src/bin/psql/describe.h
src/bin/psql/help.c
src/include/utils/acl.h
src/test/regress/expected/rolenames.out
src/test/regress/sql/rolenames.sql