Adrian Klaver <adrian.klaver@gmail.com> writes:
> After reading the above thread here is what the queries mentioned return:
> production=# SELECT nspname,proname,probin FROM pg_proc,pg_namespace
> WHERE probin LIKE '%python%' and pg_proc.pronamespace=pg_namespace.oid;
> nspname | proname | probin
> ------------+-------------------------+------------------
> pg_catalog | plpython_call_handler | $libdir/plpython
> pg_catalog | plpython_inline_handler | $libdir/plpython
> public | plpython_call_handler | $libdir/plpython
> (3 rows)
I think what you need to do is drop the one in public, ie
drop function public.plpython_call_handler();
The other two are what the language is actually using nowadays.
Hopefully pg_upgrade will then cope with upgrading them ...
regards, tom lane