From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2 |
Date: | 2012-05-27 20:53:25 |
Message-ID: | 4FC29445.4080007@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 05/27/2012 01:35 PM, Tom Lane wrote:
> Adrian Klaver<adrian(dot)klaver(at)gmail(dot)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.
I will give that a try.
Though knowing what the problem is I wonder if another solution is to
make the plpythonu lib layout follow the description of the 2/3 split
detailed here:
http://www.postgresql.org/docs/9.2/static/plpython-python23.html
In particular:
"The language named plpythonu implements PL/Python based on the default
Python language variant, which is currently Python 2"
In other words automatically create a symlink:
plpython.so -> plpython2.so*
>
> Hopefully pg_upgrade will then cope with upgrading them ...
>
> regards, tom lane
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-05-28 14:19:55 | Re: BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2 |
Previous Message | Tom Lane | 2012-05-27 20:35:15 | Re: BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2 |