Ok - I understand! However, could that be stated in the documentation so that is clear?
-----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, June 21, 2016 2:27 PM To: Alvaro Herrera Cc: Michael Paquier; Michelle Schwan; pgsql-docs@postgresql.org Subject: Re: [DOCS] DROP EXTENSION Alvaro Herrera <alvhe...@2ndquadrant.com> 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 extension is dropped, this function remains (of > course) but it stops working. Ah, I kind of suspected that: the issue is that we don't analyze function bodies to detect dependencies therein. In a perfect world we would, but there are daunting obstacles in the way. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
