Re: creating extension including dependencies - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: creating extension including dependencies
Date
Msg-id CAMkU=1wq+iB3sSKrYgDcdwTfSZuZXq96D2cN+AwgZz2zVxpb5A@mail.gmail.com
Whole thread Raw
In response to Re: creating extension including dependencies  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: creating extension including dependencies
List pgsql-hackers
On Tue, Sep 15, 2015 at 8:44 PM, Petr Jelinek <petr@2ndquadrant.com> wrote:
On 2015-09-08 04:06, Michael Paquier wrote:
On Tue, Sep 8, 2015 at 10:44 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:

Attached are as well changes for the documentation that I spotted in
earlier reviews but were not included in the last version sent by Petr
yesterday. Feel free to discard them if you think they are not
adapted, the patch attached applies on top of Petr's patch.

And /log/ is missing in src/test/modules/extensions/.gitignore.


Ah sorry, I based it on my branch which didn't contain your changes. Merged.

If I fail to specify CASCADE and get an ERROR, I think there should be a HINT which suggests the use of CASCADE.


create extension earthdistance ;
ERROR:  required extension "cube" is not installed

(no hint)

There is a HINT on the reverse operation:
drop extension cube;
ERROR:  cannot drop extension cube because other objects depend on it
DETAIL:  extension earthdistance depends on extension cube
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

Also, It would be nice to have psql tab complete the word CASCADE.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: On-demand running query plans using auto_explain and signals
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_resetxlog sentences