Re: [DOCS] DROP EXTENSION

2016-06-23 Thread Tom Lane
Magnus Hagander writes: > On Thu, Jun 23, 2016 at 3:32 AM, Bruce Momjian wrote: >> On Tue, Jun 21, 2016 at 08:15:35PM -0400, Tom Lane wrote: >>> Results should be visible at >>> https://www.postgresql.org/docs/devel/static/ddl-depend.html >>> in half an hour or so. >> Uh, I don't think that buil

Re: [DOCS] DROP EXTENSION

2016-06-23 Thread Bruce Momjian
On Thu, Jun 23, 2016 at 09:25:26AM +0200, Magnus Hagander wrote: > > > On Thu, Jun 23, 2016 at 3:32 AM, Bruce Momjian wrote: > > On Tue, Jun 21, 2016 at 08:15:35PM -0400, Tom Lane wrote: > > Michelle Schwan writes: > > > That sounds good (but in my case there was no "silent drop"!)

Re: [DOCS] DROP EXTENSION

2016-06-23 Thread Magnus Hagander
On Thu, Jun 23, 2016 at 3:32 AM, Bruce Momjian wrote: > On Tue, Jun 21, 2016 at 08:15:35PM -0400, Tom Lane wrote: > > Michelle Schwan writes: > > > That sounds good (but in my case there was no "silent drop"!). > > > I would presume that standard functionality would be drop cascade > drops all d

Re: [DOCS] DROP EXTENSION

2016-06-22 Thread Bruce Momjian
On Tue, Jun 21, 2016 at 08:15:35PM -0400, Tom Lane wrote: > Michelle Schwan writes: > > That sounds good (but in my case there was no "silent drop"!). > > I would presume that standard functionality would be drop cascade drops all > > dependent and just drop errors if extension is used anywhere.

Re: [DOCS] DROP EXTENSION

2016-06-22 Thread Michelle Schwan
: [DOCS] DROP EXTENSION Alvaro Herrera writes: > Right; mschwan wrote private email to indicate that the function in > question is: > CREATE OR REPLACE FUNCTION public.f_unaccent(text) > RETURNS text AS > $$ > select public.unaccent('public.unaccent', $1) $$ > LAN

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Tom Lane
Michelle Schwan writes: > That sounds good (but in my case there was no "silent drop"!). > I would presume that standard functionality would be drop cascade drops all > dependent and just drop errors if extension is used anywhere. But, in the > meantime, I think the documentation should reflect

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Tom Lane
Michelle Schwan writes: > Ok - I understand! > However, could that be stated in the documentation so that is clear? I had thought it *was* documented, but can't find such a statement at the moment. However, the natural place to document it would be in section 5.13 "Dependency Tracking", and/or i

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > Right; mschwan wrote private email to indicate that the function in > > question is: > > > CREATE OR REPLACE FUNCTION public.f_unaccent(text) > > RETURNS text AS > > $$ > > select public.unaccent('public.unaccent', $1) > > $$ > > LANGUAGE sql IMM

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Tom Lane
Alvaro Herrera writes: > Right; mschwan wrote private email to indicate that the function in > question is: > CREATE OR REPLACE FUNCTION public.f_unaccent(text) > RETURNS text AS > $$ > select public.unaccent('public.unaccent', $1) > $$ > LANGUAGE sql IMMUTABLE; > so when the unaccent exte

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Alvaro Herrera
Alvaro Herrera wrote: > Michael Paquier wrote: > > On Tue, Jun 21, 2016 at 1:00 AM, 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 (with

Re: [DOCS] DROP EXTENSION

2016-06-21 Thread Alvaro Herrera
Michael Paquier wrote: > On Tue, Jun 21, 2016 at 1:00 AM, 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

Re: [DOCS] DROP EXTENSION

2016-06-20 Thread Michael Paquier
On Tue, Jun 21, 2016 at 1:00 AM, 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. >

[DOCS] DROP EXTENSION

2016-06-20 Thread mschwan
The following documentation comment has been logged on the website: 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 f