On Fri, Jul 5, 2013 at 9:45 AM, Noah Misch n...@leadboat.com wrote:
REFRESH MATERIALIZED VIEW should temporarily switch the current user ID to the
MV owner. REINDEX and VACUUM do so to let privileged users safely maintain
objects owned by others, and REFRESH MATERIALIZED VIEW belongs in that
On Fri, Jul 05, 2013 at 11:18:50PM -0700, Hitoshi Harada wrote:
On Fri, Jul 5, 2013 at 9:45 AM, Noah Misch n...@leadboat.com wrote:
REFRESH MATERIALIZED VIEW should temporarily switch the current user ID to
the
MV owner. REINDEX and VACUUM do so to let privileged users safely maintain
REFRESH MATERIALIZED VIEW should temporarily switch the current user ID to the
MV owner. REINDEX and VACUUM do so to let privileged users safely maintain
objects owned by others, and REFRESH MATERIALIZED VIEW belongs in that class
of commands. The MV query then runs as a security-restricted