pgsql: Make it possibly to specify GUC params per user and per database.
От | alvherre@postgresql.org (Alvaro Herrera) |
---|---|
Тема | pgsql: Make it possibly to specify GUC params per user and per database. |
Дата | |
Msg-id | 20091007221426.6BB98753FB7@cvs.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Log Message: ----------- 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. Modified Files: -------------- pgsql/doc/src/sgml: catalogs.sgml (r2.208 -> r2.209) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.208&r2=2.209) pgsql/doc/src/sgml/ref: alter_role.sgml (r1.14 -> r1.15) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_role.sgml?r1=1.14&r2=1.15) pgsql/src/backend/catalog: Makefile (r1.72 -> r1.73) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/Makefile?r1=1.72&r2=1.73) catalog.c (r1.83 -> r1.84) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/catalog.c?r1=1.83&r2=1.84) pg_shdepend.c (r1.35 -> r1.36) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_shdepend.c?r1=1.35&r2=1.36) system_views.sql (r1.60 -> r1.61) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql?r1=1.60&r2=1.61) pgsql/src/backend/commands: dbcommands.c (r1.226 -> r1.227) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c?r1=1.226&r2=1.227) user.c (r1.188 -> r1.189) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c?r1=1.188&r2=1.189) pgsql/src/backend/nodes: copyfuncs.c (r1.440 -> r1.441) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c?r1=1.440&r2=1.441) equalfuncs.c (r1.363 -> r1.364) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c?r1=1.363&r2=1.364) pgsql/src/backend/parser: gram.y (r2.680 -> r2.681) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.680&r2=2.681) pgsql/src/backend/utils/init: miscinit.c (r1.177 -> r1.178) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/miscinit.c?r1=1.177&r2=1.178) postinit.c (r1.197 -> r1.198) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c?r1=1.197&r2=1.198) pgsql/src/bin/pg_dump: dumputils.c (r1.49 -> r1.50) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.c?r1=1.49&r2=1.50) dumputils.h (r1.26 -> r1.27) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.h?r1=1.26&r2=1.27) pg_dumpall.c (r1.127 -> r1.128) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c?r1=1.127&r2=1.128) pgsql/src/bin/psql: command.c (r1.208 -> r1.209) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c?r1=1.208&r2=1.209) describe.c (r1.227 -> r1.228) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c?r1=1.227&r2=1.228) describe.h (r1.41 -> r1.42) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.h?r1=1.41&r2=1.42) pgsql/src/include/catalog: catversion.h (r1.541 -> r1.542) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.541&r2=1.542) dependency.h (r1.41 -> r1.42) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/dependency.h?r1=1.41&r2=1.42) indexing.h (r1.109 -> r1.110) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/indexing.h?r1=1.109&r2=1.110) pg_attribute.h (r1.153 -> r1.154) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_attribute.h?r1=1.153&r2=1.154) pg_authid.h (r1.9 -> r1.10) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_authid.h?r1=1.9&r2=1.10) pg_database.h (r1.50 -> r1.51) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_database.h?r1=1.50&r2=1.51) toasting.h (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/toasting.h?r1=1.8&r2=1.9) pgsql/src/include/nodes: parsenodes.h (r1.404 -> r1.405) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.404&r2=1.405) pgsql/src/include/utils: guc.h (r1.106 -> r1.107) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h?r1=1.106&r2=1.107) pgsql/src/test/regress/expected: rules.out (r1.150 -> r1.151) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out?r1=1.150&r2=1.151) sanity_check.out (r1.41 -> r1.42) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/sanity_check.out?r1=1.41&r2=1.42) Added Files: ----------- pgsql/src/backend/catalog: pg_db_role_setting.c (r1.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_db_role_setting.c?rev=1.1&content-type=text/x-cvsweb-markup) pgsql/src/include/catalog: pg_db_role_setting.h (r1.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_db_role_setting.h?rev=1.1&content-type=text/x-cvsweb-markup)
В списке pgsql-committers по дате отправления:
Предыдущее
От: alvherre@postgresql.org (Alvaro Herrera)Дата:
Сообщение: pgsql: Fix snapshot management, take two.
Следующее
От: tgl@postgresql.org (Tom Lane)Дата:
Сообщение: pgsql: Support use of function argument names to identify which actual