postgres.git / summary / log / commit / refs

commit    9f0f4efc2f1ebbf37c1d52cb8c983d5dad65dcd6
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Tue Aug 15 23:27:22 2017 +0000

    Include foreign tables in information_schema.table_privileges
    
    This appears to have been an omission in the original commit
    0d692a0dc9f.  All related information_schema views already include
    foreign tables.
    
    Reported-by: Nicolas Thauvin <nicolas.thauvin@dalibo.com>


 src/backend/catalog/information_schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql
index e1f8e7f4b1c..94915c87b38 100644
--- a/src/backend/catalog/information_schema.sql
+++ b/src/backend/catalog/information_schema.sql
@@ -1838,7 +1838,7 @@ CREATE VIEW table_privileges AS
          ) AS grantee (oid, rolname)
 
     WHERE c.relnamespace = nc.oid
-          AND c.relkind IN ('r', 'v')
+          AND c.relkind IN ('r', 'v', 'f')
           AND c.grantee = grantee.oid
           AND c.grantor = u_grantor.oid
           AND c.prtype IN ('INSERT', 'SELECT', 'UPDATE', 'DELETE', 'TRUNCATE', 'REFERENCES', 'TRIGGER')


[parent: cd184273ba9d]