Python 2.7.10: undefined symbol: PyUnicodeUCS4_AsUTF8String

[bmcorser]

Not sure if this is a pyenv issue, but posting here anyhoo. There seems some issue regarding unicode representations.

$ pyenv versions
  system
* 2.7.10 (set by /home/ben/.pyenv/version)
  2.7.8
$ python -c 'from psycopg2.extras import NumericRange'
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/home/ben/.pyenv/versions/2.7.10/lib/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>
    from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: /home/ben/.pyenv/versions/2.7.10/lib/python2.7/site-packages/psycopg2/_psycopg.so: undefined symbol: PyUnicodeUCS4_AsUTF8String

Any advices?

[bmcorser]

One more google away suggests this could be related to how I am installing psycopg2 (I used pip install pyscopg2)

[bmcorser]

Ah -- I think this is actually a known psycopg2 issue, since Pip installs from wheels (pre-compiled packages, AFAIK) so the error makes a little more sense. If I install from sauce, things seem OK:

$ pip uninstall psycopg2
$ git clone https://github.com/psycopg/psycopg2
$ cd psycopg2
$ python setup.py build
$ python setup.py install
$ python -c 'from psycopg2.extras import NumericRange'
$ echo $?
0

[twig]

Thanks for that @bmcorser, that solved my issues with UCS4.

[brownchow]

Ah -- I think this is actually a known psycopg2 issue, since Pip installs from wheels (pre-compiled packages, AFAIK) so the error makes a little more sense. If I install from sauce, things seem OK:

$ pip uninstall psycopg2
$ git clone https://github.com/psycopg/psycopg2
$ cd psycopg2
$ python setup.py build
$ python setup.py install
$ python -c 'from psycopg2.extras import NumericRange'
$ echo $?
0

thanks a lot, I rebuild myself then slove the problem.

[Iva-khar]

Ah -- I think this is actually a known psycopg2 issue, since Pip installs from wheels (pre-compiled packages, AFAIK) so the error makes a little more sense. If I install from sauce, things seem OK:

$ pip uninstall psycopg2
$ git clone https://github.com/psycopg/psycopg2
$ cd psycopg2
$ python setup.py build
$ python setup.py install
$ python -c 'from psycopg2.extras import NumericRange'
$ echo $?
0

Thanks @bmcorser