> On Aug 18, 2018, at 5:26 PM, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Saturday, August 18, 2018, Jonathan S. Katz <jk...@postgresql.org > <mailto:jk...@postgresql.org>> wrote: > It’s cosmetic, but it’s a cosmetic bug: it incorrectly tells the user that > they > must be the owner of the “relational” when in reality it’s the materialized > view. > > Materialized views are a type of relation so it is not wrong, just one of > many instances where we generalize to "relation" based in implementation > details ins team of being explicit about which type of relation is being > affected.
Sure, that’s technically correct, but it’s still confusing to a user, particularly in this cased since the error comes from running "REFRESH MATERIALIZED VIEW" which is only applied to materialized views. For instance, if you try running the command on a table: CREATE TABLE a (x int); REFRESH MATERIALIZED VIEW a; ERROR: "a" is not a materialized view which is what you would and should expect. Jonathan
signature.asc
Description: Message signed with OpenPGP