Horton

Replace pg_shadow and pg_group by new role-capable catalogs pg_authid

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

View on postgr.es
Commit: 7762619e95272974f90a38d8d85aafbe0e94add5
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2005-06-28T05:09:14Z
Releases: 8.1.0 
Replace pg_shadow and pg_group by new role-capable catalogs pg_authid
and pg_auth_members.  There are still many loose ends to finish in this
patch (no documentation, no regression tests, no pg_dump support for
instance).  But I'm going to commit it now anyway so that Alvaro can
make some progress on shared dependencies.  The catalog changes should
be pretty much done.

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +530 −230
doc/src/sgml/func.sgml modified +6 −6
src/backend/access/transam/twophase.c modified +7 −7
src/backend/access/transam/xact.c modified +7 −5
src/backend/catalog/aclchk.c modified +124 −162
src/backend/catalog/genbki.sh modified +10 −2
src/backend/catalog/information_schema.sql modified +40 −46
src/backend/catalog/Makefile modified +4 −3
src/backend/catalog/namespace.c modified +13 −13
src/backend/catalog/pg_conversion.c modified +3 −3
src/backend/catalog/pg_namespace.c modified +3 −3
src/backend/catalog/pg_operator.c modified +3 −3
src/backend/catalog/pg_proc.c modified +2 −2
src/backend/catalog/pg_type.c modified +2 −2
src/backend/catalog/system_views.sql modified +43 −7
src/backend/commands/aggregatecmds.c modified +4 −4
src/backend/commands/alter.c modified +6 −10
src/backend/commands/conversioncmds.c modified +4 −4
src/backend/commands/copy.c modified +1 −2
src/backend/commands/dbcommands.c modified +24 −26
src/backend/commands/functioncmds.c modified +5 −5
src/backend/commands/opclasscmds.c modified +5 −5
src/backend/commands/operatorcmds.c modified +4 −4
src/backend/commands/schemacmds.c modified +16 −17
src/backend/commands/tablecmds.c modified +14 −14
src/backend/commands/tablespace.c modified +13 −17
src/backend/commands/typecmds.c modified +4 −4
src/backend/commands/user.c modified +583 −752
src/backend/commands/variable.c modified +28 −28
src/backend/executor/execMain.c modified +2 −2
src/backend/executor/nodeAgg.c modified +2 −2
src/backend/libpq/crypt.c modified +24 −15
src/backend/libpq/hba.c modified +89 −187
src/backend/nodes/copyfuncs.c modified +45 −69
src/backend/nodes/equalfuncs.c modified +35 −55
src/backend/nodes/outfuncs.c modified +2 −2
src/backend/nodes/readfuncs.c modified +2 −2
src/backend/parser/gram.y modified +296 −108
src/backend/parser/keywords.c modified +2 −1
src/backend/parser/parse_relation.c modified +6 −6
src/backend/postmaster/pgstat.c modified +1 −2
src/backend/postmaster/postmaster.c modified +8 −11
src/backend/rewrite/rewriteDefine.c modified +7 −7
src/backend/rewrite/rewriteHandler.c modified +2 −2
src/backend/tcop/utility.c modified +38 −57
src/backend/utils/adt/acl.c modified +369 −365
src/backend/utils/adt/pgstatfuncs.c modified +2 −3
src/backend/utils/adt/ri_triggers.c modified +3 −3
src/backend/utils/adt/ruleutils.c modified +15 −15
src/backend/utils/cache/lsyscache.c modified +20 −53
src/backend/utils/cache/syscache.c modified +43 −43
src/backend/utils/fmgr/fmgr.c modified +3 −3
src/backend/utils/init/flatfiles.c modified +263 −281
src/backend/utils/init/miscinit.c modified +47 −48
src/backend/utils/init/postinit.c modified +18 −14
src/backend/utils/misc/guc.c modified +3 −3
src/backend/utils/misc/superuser.c modified +31 −31
src/bin/initdb/initdb.c modified +15 −16
src/include/access/twophase.h modified +2 −2
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/indexing.h modified +11 −11
src/include/catalog/pg_attribute.h modified +7 −7
src/include/catalog/pg_authid.h added +94 −0
src/include/catalog/pg_auth_members.h added +54 −0
src/include/catalog/pg_class.h modified +2 −2
src/include/catalog/pg_conversion.h modified +3 −3
src/include/catalog/pg_database.h modified +2 −2
src/include/catalog/pg_group.h deleted +0 −45
src/include/catalog/pg_namespace.h modified +3 −3
src/include/catalog/pg_opclass.h modified +2 −2
src/include/catalog/pg_operator.h modified +2 −2
src/include/catalog/pg_proc.h modified +30 −30
src/include/catalog/pg_shadow.h deleted +0 −78
src/include/catalog/pg_tablespace.h modified +2 −2
src/include/catalog/pg_type.h modified +2 −2
src/include/c.h modified +2 −6
src/include/commands/conversioncmds.h modified +2 −2
src/include/commands/dbcommands.h modified +2 −2
src/include/commands/defrem.h modified +5 −5
src/include/commands/schemacmds.h modified +2 −2
src/include/commands/tablespace.h modified +2 −2
src/include/commands/typecmds.h modified +2 −2
src/include/commands/user.h modified +8 −12
src/include/libpq/hba.h modified +3 −4
src/include/miscadmin.h modified +9 −9
src/include/nodes/nodes.h modified +6 −8
src/include/nodes/parsenodes.h modified +37 −46
src/include/pgstat.h modified +2 −2
src/include/utils/acl.h modified +57 −74
src/include/utils/flatfiles.h modified +3 −5
src/include/utils/lsyscache.h modified +3 −3
src/include/utils/syscache.h modified +24 −24
src/test/regress/expected/privileges.out modified +21 −21
src/test/regress/expected/rules.out modified +6 −3
src/test/regress/expected/sanity_check.out modified +2 −2
src/test/regress/sql/privileges.sql modified +17 −17