Add per-user and per-database connection limit options.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: d42cf5a42a42689f68bc1ee1200aca75f954b1fd

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2005-07-31T17:19:22Z

Add per-user and per-database connection limit options.
This patch also includes preliminary update of pg_dumpall for roles.
Petr Jelinek, with review by Bruce Momjian and Tom Lane.

Files

Path	Change	+/−
doc/src/sgml/catalogs.sgml	modified	+31 −1
doc/src/sgml/ref/alter_database.sgml	modified	+25 −4
doc/src/sgml/ref/alter_role.sgml	modified	+3 −1
doc/src/sgml/ref/alter_user.sgml	modified	+2 −1
doc/src/sgml/ref/create_database.sgml	modified	+20 −2
doc/src/sgml/ref/create_role.sgml	modified	+19 −1
doc/src/sgml/ref/create_user.sgml	modified	+2 −1
src/backend/access/transam/twophase.c	modified	+2 −1
src/backend/catalog/system_views.sql	modified	+2 −1
src/backend/commands/dbcommands.c	modified	+106 −1
src/backend/commands/user.c	modified	+33 −1
src/backend/nodes/copyfuncs.c	modified	+15 −1
src/backend/nodes/equalfuncs.c	modified	+13 −1
src/backend/parser/gram.y	modified	+57 −33
src/backend/parser/keywords.c	modified	+2 −1
src/backend/storage/ipc/procarray.c	modified	+55 −1
src/backend/storage/lmgr/proc.c	modified	+4 −1
src/backend/tcop/utility.c	modified	+10 −1
src/backend/utils/init/miscinit.c	modified	+43 −6
src/backend/utils/init/postinit.c	modified	+36 −11
src/bin/pg_dump/pg_dumpall.c	modified	+264 −86
src/include/catalog/catversion.h	modified	+2 −2
src/include/catalog/pg_authid.h	modified	+8 −6
src/include/catalog/pg_database.h	modified	+11 −9
src/include/commands/dbcommands.h	modified	+2 −1
src/include/nodes/nodes.h	modified	+2 −1
src/include/nodes/parsenodes.h	modified	+8 −1
src/include/storage/procarray.h	modified	+3 −1
src/include/storage/proc.h	modified	+2 −1
src/test/regress/expected/rules.out	modified	+1 −1