I wrote:
> But now that you mention it, isn't that completely broken? What pg_dump
> actually prints given this made-up data is
> REVOKE ALL ON TYPE myshell FROM PUBLIC;
> REVOKE ALL ON TYPE myshell FROM postgres;
> GRANT ALL ON TYPE myshell TO PUBLIC;
> which seems like a completely insane interpretation. There is no way
> that dumping a type from a pre-typacl database and restoring it into
> a newer one should end up with the type's owner having no privileges
> on it. I'm astonished that we've not gotten bug reports about that.
... of course, the reason for no field reports is that the owner still
has privileges, as she inherits them from PUBLIC. Doesn't make this
any less broken though.
regards, tom lane
