title: undefined symbol: PyUnicodeUCS2_Decode whilst trying to install psycopg2
body: <p>I'm getting an error whilst trying to install psycopg2 on ubuntu 9.10 64 bit.</p>
  
  <p>The error is:</p>
  
  <pre><code>&gt;&gt;&gt; import psycopg2
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "psycopg2/__init__.py", line 69, in &lt;module&gt;
      from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
  ImportError: psycopg2/_psycopg.so: undefined symbol: PyUnicodeUCS2_Decode
  </code></pre>
  
  <p>I've tried downloading the package from <a href="http://initd.org/pub/software/psycopg/" rel="noreferrer">http://initd.org/pub/software/psycopg/</a> and installing it. I've tried by using easy_install too.</p>
  
  <p>No error during the installation.</p>
  
  <p>It's quite weird as my python (2.6.2) has been compiled with UCS4 and so the installation should just work without problems.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Cheers</p>