Commit 36f887c

committed

Speed up information schema privilege views

Instead of expensive cross joins to resolve the ACL, add table-returning function aclexplode() that expands the ACL into a useful form, and join against that. Also, implement the role_*_grants views as a thin layer over the respective *_privileges views instead of essentially repeating the same code twice. fixes bug #4596 by Joachim Wieland, with cleanup by me

1 parent 636bac6 commit 36f887cCopy full SHA for 36f887c

5 files changed

+301

-232

lines changed

src
- backend
  - catalog
    - information_schema.sql
  - utils/adt
    - acl.c
- include
  - catalog
    - catversion.h
    - pg_proc.h
  - utils
    - acl.h

5 files changed

+301

-232

lines changed

Comments

(0)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit 36f887c

5 files changed

5 files changed

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!

File tree

5 files changed

5 files changed

0 commit comments

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!