Hello, our production database has existed for quite a few years and been dumped/restored several times for hardware or postgresql upgrades. Original version was late 7 or early 8, we're currently on 8.4.2. I noticed on our production database I have two call handlers for plpgsql and for plpython; the following query:
select pn.nspname, pu0.usename as nspowner, pp.proname, pu1.usename as proowner, pp.prosrc, pp.probin from pg_proc pp, pg_namespace pn, pg_user pu0, pg_user pu1 where pp.proname like '%call_handler%' and pn.oid = pp.pronamespace and pu0.usesysid = pn.nspowner and pu1.usesysid = pp.proowner order by pp.proname;