From 7a9fe9ea7b1308794125dfc4af7994bff204fc41 Mon Sep 17 00:00:00 2001 From: Andrey Klychkov Date: Mon, 24 Jun 2019 15:38:12 +0300 Subject: postgresql_privs: bugfix of 27327 - incorrect views handling (#58272) (cherry picked from commit 278c59b17e9ff781e61017ca6fdcc2b86288d146) --- lib/ansible/modules/database/postgresql/postgresql_privs.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/ansible/modules') 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()] -- cgit v1.2.1