Triggered by having multiple plpython_call_handler() functions
installed, one in the expected pg_catalog namespace and the other in the
unexpected public namespace.

In this case, "SELECT nspname,proname,probin FROM pg_proc,pg_namespace
WHERE probin LIKE '%python%' and pg_proc.pronamespace=pg_namespace.oid;"
shows the two handlers, and "DROP FUNCTION
public.plpython_call_handler();" removes the errant one. pg_upgrade then
completes happily.

Bug is still open, deciding on if pg_upgrade should handle this case.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/920926

Title:
  pg_upgrade fails with plpython stored procedures

To manage notifications about this bug go to:
https://bugs.launchpad.net/postgresql/+bug/920926/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to