OSDN Git Service

Make it possibly to specify GUC params per user and per database.
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 7 Oct 2009 22:14:26 +0000 (22:14 +0000)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 7 Oct 2009 22:14:26 +0000 (22:14 +0000)
commit2eda8dfb52ed9962920282d8384da8bb4c22514d
treea89217bd461bda210a8ebaab0cef924cac53d863
parent07cefdfb7a1c1a7ae96783c9723102250a4c3bad
Make it possibly to specify GUC params per user and per database.

Create a new catalog pg_db_role_setting where they are now stored, and better
encapsulate the code that deals with settings into its realm.  The old
datconfig and rolconfig columns are removed.

psql has gained a \drds command to display the settings.

Backwards compatibility warning: while the backwards-compatible system views
still have the config columns, they no longer completely represent the
configuration for a user or database.

Catalog version bumped.
32 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/alter_role.sgml
src/backend/catalog/Makefile
src/backend/catalog/catalog.c
src/backend/catalog/pg_db_role_setting.c [new file with mode: 0644]
src/backend/catalog/pg_shdepend.c
src/backend/catalog/system_views.sql
src/backend/commands/dbcommands.c
src/backend/commands/user.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/utils/init/miscinit.c
src/backend/utils/init/postinit.c
src/bin/pg_dump/dumputils.c
src/bin/pg_dump/dumputils.h
src/bin/pg_dump/pg_dumpall.c
src/bin/psql/command.c
src/bin/psql/describe.c
src/bin/psql/describe.h
src/include/catalog/catversion.h
src/include/catalog/dependency.h
src/include/catalog/indexing.h
src/include/catalog/pg_attribute.h
src/include/catalog/pg_authid.h
src/include/catalog/pg_database.h
src/include/catalog/pg_db_role_setting.h [new file with mode: 0644]
src/include/catalog/toasting.h
src/include/nodes/parsenodes.h
src/include/utils/guc.h
src/test/regress/expected/rules.out
src/test/regress/expected/sanity_check.out