Re: Python UCS4 error

[c k <shreeseva.learning@xxxxxxxxx>]

I have default python 2.7.1 installed along with fedora15. Then installed postgresql from binary installers. This creates the plpython.so, plpython2.so and plpython3.so in lib/postgresql directory under postgresql installation. When I go for creating a new language plpython, it gives me some error regarding pythonś version. By default it is compiled with 2.6 and I have 2.7, so I need to get source code and compile it against python 2.7. For this I will configure --with-python option and see which python it uses and where it is located. For me it used python 2.7 and shown the python default installation. Then I used ´make' and ´make install world´ and copied plpython.so and plpython2.so to new postgresql installation. Started the server and try to create new language, then the earlier mentioned error comes as
undefined symbol: PyUnicodeUCS4_AsEncodedString. 
Previously It was working on fedora 14 . It seems that I have to recompile and install python 2.7 at another location and use it for postgresql make process. But not sure that it will solve error.
Thanks and regards,

C P Kulkarni

On Wed, Jul 6, 2011 at 12:24 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

c k <shreeseva.learning@xxxxxxxxx> writes:
> I updated my development machine with Fedora 15 and as there is python 2.7.
> I have also migrated my few postgresql databases. While creating plpython in
> one database, I got the following error undefined symbol
> PyUnicodeUCS4_AsEncodedString.
> Then I recompiled source code and got a plpython.so compiled for python 2.7
> (default python comes with fedora15) and replaced original with this one.
> Restarted postgresql and still same error occurs.

plpython seems to work for me on Fedora 15, so you're going to need to
be more specific about how to trigger this error.

                       regards, tom lane