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
On Wed, Jul 6, 2011 at 9:25 AM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 07/05/11 8:33 PM, c k wrote:any reason you didn't use the Fedora 15 native version of Postgres 9.0.x ? should be as simple as
yes, shipped with fedora 15 and binary installers are from EnterpriseDB - all in one.
$ sudo yum install postgresql-server
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
