Inzamam Shafiq <inzamam.shafiq@hotmail.com> writes:
> I came across an issue while working with acldefault function on materialized view, which threw an error "ERROR:
unrecognizedobjtype abbreviation: m", when I looked at the source code of acldefault_sql it seems that materialized
viewcase is not handled there, the SQL statement which I was executing is as follows,
No, acldefault doesn't consider 'm' to be valid input, because
materialized views are not a distinct kind of object for ACL purposes;
they're just relations (tables), and have relation-y privileges.
In fact, none of the object type codes accepted by acldefault_sql
are relkind values, except for the accidental overlap of 'r' with
the relkind for plain tables.
regards, tom lane
