Re: 2.4.2: undefined symbol: lo_truncate

On Thu, Oct 6, 2011 at 3:33 PM, Matthew Robinson
<matthew(dot)robinson(at)umassd(dot)edu> wrote:
> Warning, a python neophyte here so I am more than likely missing something.
>
> I'm trying to use 2.4.2 (and also tried 2.4.1 with same error, 2.4.0 with a
> different error...) under Ubuntu with the intention of trying out
> ReviewBoard.
>
> launching python and attempting to import psycopg2 yields:
> --------
>>>> import psycopg2
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
>   File "/usr/local/lib/python2.6/
> dist-packages/psycopg2/__init__.py", line 67, in <module>
>     from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
> ImportError: /usr/local/lib/python2.6/dist-packages/psycopg2/_psycopg.so:
> undefined symbol: lo_truncate

lo_truncate is available after postgres 8.3. Psycopg is being compiled
again libpq 8.4, so the function is included. Looks like at runtime it
tries to dynamically link with an older libpq: you can check with ldd
which one.

-- Daniele