[GENERAL] Why is materialized view creation a "security-restricted operation"?

y, this is actually quite surprising to me, given that tables and views work just fine. What makes a materialized view so different? Are there any plans to make this more consistent? Thanks for any help you can provide. Regards, Joshua Chamberlain [1] https://www.postgresql.org/

Re: [GENERAL] Why is materialized view creation a "security-restricted operation"?

unexpected side-effects. But if REFRESH MATERIALIZED VIEW is generally used in higher-privilege session, I guess that could make sense. I'll just have to adjust my code a bit. Thanks, Joshua Chamberlain On Tue, Jan 24, 2017 at 3:18 AM, Albe Laurenz wrote: > Joshua Chamberlain wrote:

[GENERAL] CREATE TABLE with parallel workers, 10.0?

ans in 10.0 to allow parallelism in queries that write, or at least in "CREATE TABLE AS" queries? Thanks, Joshua Chamberlain