Evan Martin <postgresql@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
