diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-08-15 19:27:22 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-08-15 19:30:35 -0400 |
| commit | 3ea58216de4b26e27be8c6b23e44e275804542f2 (patch) | |
| tree | c5b34bdadb8f1e59a8925dfb6787e59a07f89054 /src | |
| parent | 7502f399de38c68d2bb327e4071dd2fcdb5a20e6 (diff) | |
| download | postgresql-3ea58216de4b26e27be8c6b23e44e275804542f2.tar.gz postgresql-3ea58216de4b26e27be8c6b23e44e275804542f2.zip | |
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>
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 98bcfa08c65..5398271ad01 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -1868,7 +1868,7 @@ CREATE VIEW table_privileges AS ) AS grantee (oid, rolname) WHERE c.relnamespace = nc.oid - AND c.relkind IN ('r', 'v', 'p') + AND c.relkind IN ('r', 'v', 'f', 'p') AND c.grantee = grantee.oid AND c.grantor = u_grantor.oid AND c.prtype IN ('INSERT', 'SELECT', 'UPDATE', 'DELETE', 'TRUNCATE', 'REFERENCES', 'TRIGGER') |