Re: Make bloom extension trusted, but can not drop with normal user

Why does that matter here though?  This isn't a question about a security violation, it's one about the basic premise that a trusted extension is owned by the creating user and thus can be dropped by them.  During installation, a trusted user is permitted to perform superuser actions by virtue of the trusted flag.  Since they are allowed to drop their own extension it is at least plausible to assume that upon doing so the dropping would be done as a superuser as well.  That this is not the case doesn't seem to be documented nor, going from the commit message for the feature, does it seem intentional.

David J.