]> granicus.if.org Git - postgresql/commit
Track dependencies on shared objects (which is to say, roles; we already
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Jul 2005 20:40:02 +0000 (20:40 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Jul 2005 20:40:02 +0000 (20:40 +0000)
commit59d1b3d99e690734fa2a2bd0fae12b0cb1084294
treeff074126ccc1a6342de38737d79e218f22fb9be4
parent442b59dd8bc4b0efa1d733690f6ba9dae3f61b1f
Track dependencies on shared objects (which is to say, roles; we already
have adequate mechanisms for tracking the contents of databases and
tablespaces).  This solves the longstanding problem that you can drop a
user who still owns objects and/or has access permissions.
Alvaro Herrera, with some kibitzing from Tom Lane.
38 files changed:
doc/src/sgml/catalogs.sgml
src/backend/catalog/Makefile
src/backend/catalog/aclchk.c
src/backend/catalog/dependency.c
src/backend/catalog/heap.c
src/backend/catalog/pg_conversion.c
src/backend/catalog/pg_namespace.c
src/backend/catalog/pg_operator.c
src/backend/catalog/pg_proc.c
src/backend/catalog/pg_shdepend.c [new file with mode: 0644]
src/backend/catalog/pg_type.c
src/backend/commands/conversioncmds.c
src/backend/commands/dbcommands.c
src/backend/commands/functioncmds.c
src/backend/commands/opclasscmds.c
src/backend/commands/operatorcmds.c
src/backend/commands/schemacmds.c
src/backend/commands/tablecmds.c
src/backend/commands/tablespace.c
src/backend/commands/typecmds.c
src/backend/commands/user.c
src/backend/utils/adt/acl.c
src/bin/initdb/initdb.c
src/include/catalog/catversion.h
src/include/catalog/dependency.h
src/include/catalog/indexing.h
src/include/catalog/pg_shdepend.h [new file with mode: 0644]
src/include/catalog/pg_type.h
src/include/utils/acl.h
src/test/regress/expected/cluster.out
src/test/regress/expected/dependency.out [new file with mode: 0644]
src/test/regress/expected/privileges.out
src/test/regress/expected/sanity_check.out
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/cluster.sql
src/test/regress/sql/dependency.sql [new file with mode: 0644]
src/test/regress/sql/privileges.sql