Why do you think that the normal user should be allowed to drop extensions?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных