Re: 2.4.2: undefined symbol: lo_truncate

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Matthew Robinson <matthew(dot)robinson(at)umassd(dot)edu>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: 2.4.2: undefined symbol: lo_truncate
Date: 2011-10-06 15:04:15
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: psycopg

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/", line 67, in <module>
>     from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
> ImportError: /usr/local/lib/python2.6/dist-packages/psycopg2/
> 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

In response to

Browse psycopg by date

  From Date Subject
Next Message Håvard Wahl Kongsgård 2011-10-10 10:57:12 Iterating through cur and cur.fetchone()
Previous Message Matthew Robinson 2011-10-06 14:33:39 2.4.2: undefined symbol: lo_truncate