summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrian Coca <bcoca@ansible.com>2015-06-30 07:57:25 -0400
committerBrian Coca <bcoca@ansible.com>2015-06-30 07:57:25 -0400
commite307967e8e9c1d90abf0bc38662bcedcd4458f39 (patch)
tree51d12a4cbf6c421b39a453c3d8f455f7c5806d8c
parent433ca93c428998ec943e8fb6abb82d64d45dd53a (diff)
parent5e82f7e11e0ac7cc7cdaeffb0787209afae79fb0 (diff)
downloadansible-modules-core-e307967e8e9c1d90abf0bc38662bcedcd4458f39.tar.gz
Merge pull request #1621 from ToBeReplaced/postgresql_privs_view_support
Make ALL_IN_SCHEMA for tables affect views
-rw-r--r--database/postgresql/postgresql_privs.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/postgresql/postgresql_privs.py b/database/postgresql/postgresql_privs.py
index 10f2361b..8fefd3de 100644
--- a/database/postgresql/postgresql_privs.py
+++ b/database/postgresql/postgresql_privs.py
@@ -315,7 +315,7 @@ class Connection(object):
query = """SELECT relname
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
- WHERE nspname = %s AND relkind = 'r'"""
+ WHERE nspname = %s AND relkind in ('r', 'v')"""
self.cursor.execute(query, (schema,))
return [t[0] for t in self.cursor.fetchall()]