pgsql: Track dependencies on shared objects (which is to say, roles; we

Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.106 -> r2.107)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.106&r2=2.107)
    pgsql/src/backend/catalog:
        Makefile (r1.54 -> r1.55)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/Makefile.diff?r1=1.54&r2=1.55)
        aclchk.c (r1.114 -> r1.115)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.114&r2=1.115)
        dependency.c (r1.44 -> r1.45)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/dependency.c.diff?r1=1.44&r2=1.45)
        heap.c (r1.285 -> r1.286)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c.diff?r1=1.285&r2=1.286)
        pg_conversion.c (r1.24 -> r1.25)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_conversion.c.diff?r1=1.24&r2=1.25)
        pg_namespace.c (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_namespace.c.diff?r1=1.14&r2=1.15)
        pg_operator.c (r1.92 -> r1.93)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_operator.c.diff?r1=1.92&r2=1.93)
        pg_proc.c (r1.131 -> r1.132)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c.diff?r1=1.131&r2=1.132)
        pg_type.c (r1.101 -> r1.102)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_type.c.diff?r1=1.101&r2=1.102)
    pgsql/src/backend/commands:
        conversioncmds.c (r1.19 -> r1.20)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/conversioncmds.c.diff?r1=1.19&r2=1.20)
        dbcommands.c (r1.164 -> r1.165)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.164&r2=1.165)
        functioncmds.c (r1.62 -> r1.63)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/functioncmds.c.diff?r1=1.62&r2=1.63)
        opclasscmds.c (r1.33 -> r1.34)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/opclasscmds.c.diff?r1=1.33&r2=1.34)
        operatorcmds.c (r1.22 -> r1.23)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/operatorcmds.c.diff?r1=1.22&r2=1.23)
        schemacmds.c (r1.31 -> r1.32)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/schemacmds.c.diff?r1=1.31&r2=1.32)
        tablecmds.c (r1.162 -> r1.163)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.162&r2=1.163)
        tablespace.c (r1.24 -> r1.25)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablespace.c.diff?r1=1.24&r2=1.25)
        typecmds.c (r1.73 -> r1.74)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/typecmds.c.diff?r1=1.73&r2=1.74)
        user.c (r1.155 -> r1.156)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c.diff?r1=1.155&r2=1.156)
    pgsql/src/backend/utils/adt:
        acl.c (r1.117 -> r1.118)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c.diff?r1=1.117&r2=1.118)
    pgsql/src/bin/initdb:
        initdb.c (r1.90 -> r1.91)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/initdb/initdb.c.diff?r1=1.90&r2=1.91)
    pgsql/src/include/catalog:
        catversion.h (r1.284 -> r1.285)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.284&r2=1.285)
        dependency.h (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/dependency.h.diff?r1=1.14&r2=1.15)
        indexing.h (r1.88 -> r1.89)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/indexing.h.diff?r1=1.88&r2=1.89)
        pg_type.h (r1.162 -> r1.163)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_type.h.diff?r1=1.162&r2=1.163)
    pgsql/src/include/utils:
        acl.h (r1.80 -> r1.81)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.80&r2=1.81)
    pgsql/src/test/regress/expected:
        cluster.out (r1.16 -> r1.17)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/cluster.out.diff?r1=1.16&r2=1.17)
        privileges.out (r1.30 -> r1.31)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/privileges.out.diff?r1=1.30&r2=1.31)
        sanity_check.out (r1.26 -> r1.27)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/sanity_check.out.diff?r1=1.26&r2=1.27)
    pgsql/src/test/regress:
        parallel_schedule (r1.28 -> r1.29)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/parallel_schedule.diff?r1=1.28&r2=1.29)
        serial_schedule (r1.27 -> r1.28)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/serial_schedule.diff?r1=1.27&r2=1.28)
    pgsql/src/test/regress/sql:
        cluster.sql (r1.8 -> r1.9)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/cluster.sql.diff?r1=1.8&r2=1.9)
        privileges.sql (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/privileges.sql.diff?r1=1.15&r2=1.16)

Added Files:
-----------
    pgsql/src/backend/catalog:
        pg_shdepend.c (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_shdepend.c?rev=1.1&content-type=text/x-cvsweb-markup)
    pgsql/src/include/catalog:
        pg_shdepend.h (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_shdepend.h?rev=1.1&content-type=text/x-cvsweb-markup)
    pgsql/src/test/regress/expected:
        dependency.out (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/dependency.out?rev=1.1&content-type=text/x-cvsweb-markup)
    pgsql/src/test/regress/sql:
        dependency.sql (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/dependency.sql?rev=1.1&content-type=text/x-cvsweb-markup)