diff options
| author | Andrey Klychkov <aaklychkov@mail.ru> | 2019-06-24 15:38:12 +0300 |
|---|---|---|
| committer | Toshio Kuratomi <a.badger@gmail.com> | 2019-06-24 15:16:07 -0700 |
| commit | 7a9fe9ea7b1308794125dfc4af7994bff204fc41 (patch) | |
| tree | 65f9f1ec582de70ea628a7208834441a09d4f9fc /lib/ansible/modules | |
| parent | 7c22c81c5c6bfdbb73f86a7f8ce32ff96a931e84 (diff) | |
| download | ansible-7a9fe9ea7b1308794125dfc4af7994bff204fc41.tar.gz | |
postgresql_privs: bugfix of 27327 - incorrect views handling (#58272)
(cherry picked from commit 278c59b17e9ff781e61017ca6fdcc2b86288d146)
Diffstat (limited to 'lib/ansible/modules')
| -rw-r--r-- | lib/ansible/modules/database/postgresql/postgresql_privs.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/ansible/modules/database/postgresql/postgresql_privs.py b/lib/ansible/modules/database/postgresql/postgresql_privs.py index 4bd321748d..4d50f9844d 100644 --- a/lib/ansible/modules/database/postgresql/postgresql_privs.py +++ b/lib/ansible/modules/database/postgresql/postgresql_privs.py @@ -541,7 +541,7 @@ class Connection(object): query = """SELECT relacl FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace - WHERE nspname = %s AND relkind in ('r','p') AND relname = ANY (%s) + WHERE nspname = %s AND relkind in ('r','p','v','m') AND relname = ANY (%s) ORDER BY relname""" self.cursor.execute(query, (schema, tables)) return [t[0] for t in self.cursor.fetchall()] |