]> granicus.if.org Git - postgresql/commit
Show default privileges in information schema
authorPeter Eisentraut <peter_e@gmx.net>
Fri, 27 Jan 2012 19:58:51 +0000 (21:58 +0200)
committerPeter Eisentraut <peter_e@gmx.net>
Fri, 27 Jan 2012 19:58:51 +0000 (21:58 +0200)
commitb376ec6fa57bc76037014ede29498e2d1611968e
tree2849df5a841b6779cd15629a6ba190368d4c659b
parentbf90562aa464e3a9afedde5f0007058f381d00fe
Show default privileges in information schema

Hitherto, the information schema only showed explicitly granted
privileges that were visible in the *acl catalog columns.  If no
privileges had been granted, the implicit privileges were not shown.

To fix that, add an SQL-accessible version of the acldefault()
function, and use that inside the aclexplode() calls to substitute the
catalog-specific default privilege set for null values.

reviewed by Abhijit Menon-Sen
src/backend/catalog/information_schema.sql
src/backend/utils/adt/acl.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/utils/acl.h
src/test/regress/expected/foreign_data.out
src/test/regress/sql/foreign_data.sql