has_table_privilege spawns scions has_database_privilege, has_function_privilege,
Tom Lane <tgl@sss.pgh.pa.us>
has_table_privilege spawns scions has_database_privilege, has_function_privilege, has_language_privilege, has_schema_privilege to let SQL queries test all the new privilege types in 7.3. Also, add functions pg_table_is_visible, pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible, pg_opclass_is_visible to test whether objects contained in schemas are visible in the current search path. Do some minor cleanup to centralize accesses to pg_database, as well.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/dbsize/dbsize.c | modified | +3 −21 |
| doc/src/sgml/func.sgml | modified | +208 −48 |
| src/backend/catalog/namespace.c | modified | +52 −1 |
| src/backend/commands/comment.c | modified | +9 −29 |
| src/backend/commands/dbcommands.c | modified | +76 −1 |
| src/backend/utils/adt/acl.c | modified | +868 −146 |
| src/backend/utils/adt/sets.c | modified | +3 −2 |
| src/backend/utils/misc/superuser.c | modified | +5 −23 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +70 −7 |
| src/include/commands/dbcommands.h | modified | +4 −1 |
| src/include/utils/builtins.h | modified | +25 −1 |