Thanks for your answer. My doubt is that since an ordinary user creates the extension, shouldn't be this user the owner of the objects created within the extension?
While that is a possible implementation choice, that isn't what was chosen.
"This configuration gives the calling user the right to drop the extension, but not to modify individual objects within it."
"trust" just solves the "lets not require an actual superuser to install a superuser requiring extension" problem, if that extension is deemed safe to use in that manner by its author.
