Re: [GENERAL] Python UCS4 error

Solved.
Here is the procedure to get working with plpython ucs2 or ucs4 error. By default python uses ucs2 and we have to change it to ucs4.
compile python2.7 or 3 with options as below.
./configure --enable-unicode=ucs4
then use
make and make altinstall
then use the python path for postgresql source configuration within postgresql source directory
./configure --with-python PYTHON=/usr/local/bin/python2.7 (replace with your python installation path)
then use
make and make install-world
Copy the plpython.so, plpython2.so or plpython3.so from local postgresql install directory (normally /usr/local/pgsql/lib) to the required installtion lib directory.
make proper local links to files if required.
start the postgresql
with a database create a new language as plpythonu, plpython2u or plpython3u as required.
create a simple function as below to test plpython working
CREATE or replace FUNCTION pyver() RETURNS text
    LANGUAGE plpythonu
    AS $$
import sys
#return sys.version
return sys.path
$$;

if it shown the version then check it with your newly installed alternative python version. Also check path from function and from python. If both matches then you can use plpython properly.

Regards,
C P Kulkarni