Re: pl/pyton: exceptions.ImportError: No module named

From: Eugene Prokopiev <prokopiev(at)stc(dot)donpac(dot)ru>
To: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: pl/pyton: exceptions.ImportError: No module named
Date: 2005-11-28 05:49:32
Message-ID: 438A9A6C.9000806@stc.donpac.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I use PostgreSQL 8.1.0 and Python 2.3.3

$ psql -U postgres test

test=# CREATE FUNCTION pyversion() RETURNS text AS $$
test$# import sys
test$# return sys.version + '\n' + '\n'.join(sys.path)
test$# $$ LANGUAGE plpythonu;
CREATE FUNCTION
test=# select pyversion();

pyversion

------------------------------------------------------
2.3.3 (#1, Jul 5 2004, 13:54:49)
[GCC 3.3.3 20040412 (ALT Linux, build 3.3.3-alt5)]
/usr/lib/python23.zip
/usr/lib/python2.3/
/usr/lib/python2.3/plat-linux2
/usr/lib/python2.3/lib-tk
/usr/lib/lib-dynload
(1 record)

test=# \q

$ python -c 'import sys; print sys.version, sys.path'
2.3.3 (#1, Jul 5 2004, 13:54:49)
[GCC 3.3.3 20040412 (ALT Linux, build 3.3.3-alt5)] ['',
'/usr/lib/python23.zip', '/usr/lib/python2.3',
'/usr/lib/python2.3/plat-linux2', '/usr/lib/python2.3/lib-tk',
'/usr/lib/python2.3/lib-dynload', '/usr/lib/python2.3/site-packages']

$ ldd /usr/bin/python
libpython2.3.so.1.0 => /usr/lib/libpython2.3.so.1.0 (0x00116000)
libpthread.so.0 => /lib/libpthread.so.0 (0x001fb000)
libdl.so.2 => /lib/libdl.so.2 (0x0024f000)
libutil.so.1 => /lib/libutil.so.1 (0x00253000)
libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x00257000)
libm.so.6 => /lib/libm.so.6 (0x00310000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00333000)
libc.so.6 => /lib/libc.so.6 (0x0033c000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

$ ldd /usr/lib/pgsql/plpython.so
libpython2.3.so.1.0 => /usr/lib/libpython2.3.so.1.0 (0x0011f000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00204000)
libdl.so.2 => /lib/libdl.so.2 (0x00258000)
libutil.so.1 => /lib/libutil.so.1 (0x0025c000)
libm.so.6 => /lib/libm.so.6 (0x00260000)
libc.so.6 => /lib/libc.so.6 (0x00283000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

Python versions are the same

--
Thanks,
Eugene Prokopiev

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Irina Sourikova 2005-11-28 21:39:57 BLOB handling compatibility with PostgreSQL > 7.4
Previous Message Tom Lane 2005-11-27 22:51:20 Re: PG_COMMAND_OK oid information required