Drop all overloads of a function without knowing parameter types

Поиск

Список

Период

Сортировка

От	Evan Martin
Тема	Drop all overloads of a function without knowing parameter types
Дата	3 февраля 2014 г. 17:56:01
Msg-id	52EFD825.4090508@realityexists.net обсуждение исходный текст
Ответы	Re: Drop all overloads of a function without knowing parameter types
Список	pgsql-general

Дерево обсуждения

Hi All,

Is there any easy way to drop a function (all overloads of it) without knowing the parameter types? If not, it would be good to see it added.

When I change a function definition I just want to run the SQL script that defines it and have any existing function replaced. CREATE OR REPLACE FUNCTION does this - except if the parameter types, or even names, have changed. If this SO thread is correct, it's quite tricky to drop existing functions without knowing the parameter types:

http://stackoverflow.com/questions/7622908/drop-function-without-knowing-the-number-type-of-parameters

I'd like to see a much easier way. Either something like "DROP FUNCTION name ALL" or a system function that does the same thing or at least a built-in, "supported" way to get the signature of all the overloads, so they can be dropped one by one.

Regards,

Evan

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Drop all overloads of a function without knowing parameter types