Re: ALTER EXTENSION DROP FUNCTION not working ?

Поиск
Список
Период
Сортировка
От Sandro Santilli
Тема Re: ALTER EXTENSION DROP FUNCTION not working ?
Дата
Msg-id 20160209094628.GB3901@localhost
обсуждение исходный текст
Ответ на ALTER EXTENSION DROP FUNCTION not working ?  (Sandro Santilli <strk@keybit.net>)
Ответы Re: ALTER EXTENSION DROP FUNCTION not working ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Feb 09, 2016 at 10:33:42AM +0100, Sandro Santilli wrote:

> https://trac.osgeo.org/postgis/ticket/3450#comment:23
> 
> Basically I'm getting:
> 
>  ERROR:  cannot drop function pgis_twkb_accum_finalfn(internal) because other objects depend on it
>  DETAIL:  extension postgis depends on function pgis_twkb_accum_finalfn(internal)

Figured:  the "pgis_twkb_accum_finalfn(internal)" function is not
a _direct_ dependency of extension "postgis", but is needed for
an aggregate which is still registered.

So this is more an annoyance than a bug, being the non-clear error
message about what's the direct dependent object that prevents
the drop.

--strk;



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Sandro Santilli
Дата:
Сообщение: ALTER EXTENSION DROP FUNCTION not working ?
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: checkpointer continuous flushing - V16