From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | mschwan(at)opentext(dot)com |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: DROP EXTENSION |
Date: | 2016-06-21 00:21:59 |
Message-ID: | CAB7nPqSnP6GUYqsk1Qcw5un0dj+D3YwUooM5+m7OCk8MB5xXgw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Jun 21, 2016 at 1:00 AM, <mschwan(at)opentext(dot)com> wrote:
> Page: https://www.postgresql.org/docs/9.5/static/sql-dropextension.html
> Description:
> I dropped an extension in my database with a function dependency. The
> function was dropped (without messages of dependencies) and leaving the
> function intact.
> The lines "DROP EXTENSION removes extensions from the database. Dropping an
> extension causes its component objects to be dropped as well." is not clear.
> It should be stated that by default the dependencies remain intact after
> the drop.
I am not following here. If an extension is dropped, so are its
dependencies. See that for example:
=# create extension pg_trgm;
CREATE EXTENSION
Time: 27.978 ms
=# \dx+ pg_trgm
Objects in extension "pg_trgm"
Object Description
--------------------------------------------------------------------------------------------------
function gin_extract_query_trgm(text,internal,smallint,internal,internal,internal,internal)
function gin_extract_value_trgm(text,internal)
[... lots of objects, including functions ...]
=# DROP EXTENSION pg_trgm;
DROP EXTENSION
=# \df gin_extract_query_trgm
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-06-21 16:57:25 | Re: DROP EXTENSION |
Previous Message | mschwan | 2016-06-20 16:00:47 | DROP EXTENSION |