[Fdo-trac] [fdo-trac] #949: Check if joining to pg_authid is necessary for listing materialized views

[FDO]

#949: Check if joining to pg_authid is necessary for listing materialized views
-----------------------------------+----------------------
   Reporter:  jng                  |      Owner:  jng
       Type:  task                 |     Status:  assigned
   Priority:  major                |  Milestone:  4.1.0
  Component:  PostgreSQL Provider  |    Version:  4.1.0
   Severity:  3                    |   Keywords:
External ID:                       |
-----------------------------------+----------------------
 #943 added support for materialized views. However the SQL to query for
 these materialized views includes a join to the `pg_authid` table/view
 which seems unnecessary as the joined table is not part of any output
 columns or where clauses.

 For the purpose of attack surface reduction, we should check if this join
 is even necessary and remove it if such a join is not necessary.

-- 
Ticket URL: <https://trac.osgeo.org/fdo/ticket/949>
FDO <http://fdo.osgeo.org/>
Feature Data Objects