Re: Drop all overloads of a function without knowing parameter types

Evan Martin <postgresql@realityexists.net> writes:
> Is there any easy way to drop a function (all overloads of it) without
> knowing the parameter types?

Something along the lines of

do $$
declare fname text;
begin
for fname in select oid::regprocedure from pg_proc where proname = 'foo' loop
  execute 'drop function ' || fname;
end loop;
end$$;

Adjust WHERE condition to taste.

> If not, it would be good to see it added.

People periodically ask for extensions flavored more or less like this,
but I'm suspicious of building any such thing into the core.  There's too
little commonality in the exact conditions they want to search on.
Leaving it at the level of a scripting problem, as above, allows arbitrary
customization of the search condition.

            regards, tom lane