launchpad-dev team mailing list archive

[Sidnei da Silva <sidnei.da.silva@xxxxxxxxxxxxx>]

On Thu, Sep 16, 2010 at 12:46 PM, Curtis Hovey
<curtis.hovey@xxxxxxxxxxxxx> wrote:
> =================================
> Launchpad and Storm and PyschoPG2
>
>        Storm and PyschoPG2 for Maverick break Launchpad.
>           https://bugs.launchpad.net/launchpad-foundations/+bug/631010
>
>        You will see errors in the test suite or running Lp link this:
>                ProgrammingError: operator does not exist: text = byte
>
>        The fix is to use an older version of PyschoPG The
>        python-psycopg2-2.0.13-2ubuntu2 deb can be downloaded from the
>        build page for your architecture:
>
>        https://launchpad.net/ubuntu/+source/psycopg2/2.0.13-2ubuntu2
>        Run
>            dpkg -i --force-downgrade python-psychopg2*.deb
>
>        I am reinstalling this after every update. I chose to keep this
>        unpinned because I hope this will be fixed in either Ubuntu's or
>        Launchpad's archives.

The 'fix' is actually to make sure unicode is used in the places where
raw SQL queries are constructed in Launchpad (IIRC). We fixed a
handful similar cases in Landscape and we're happily running psycopg
2.2. Thomas Herve might have more details since he landed the branch
to fix it.

-- Sidnei