Excerpts from Dimitri Fontaine's message of vie nov 05 16:58:00 -0300 2010:
> dim=> drop schema bob cascade; > NOTICE: drop cascades to extension unaccent > DROP SCHEMA > > dim=> \c - dim > You are now connected to database "dim" as user "dim". > dim=# select installed from pg_extensions where name = 'unaccent'; > installed > ----------- > f > (1 row) Basically you're saying that the owner of the schema in which the extension is installed can drop the extension ... even though, according to your previous argument, the extension is not "in" said schema :-) -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
