ProgrammingError: operator does not exist: text = bytea

Bug #631010 reported by Curtis Hovey
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Māris Fogels

Bug Description

I upgraded to maverick. I am seeing
    ProgrammingError: operator does not exist: text = bytea
when I run tests.

I am using postgres 8.4 and have the launchpad ppa deps for maverick installed. This looks like Bug #585704 in storm and if so, we want to update/patch the Lp version.

Related branches

Curtis Hovey (sinzui)
affects: launchpad → launchpad-foundations
tags: added: database maverick storm
Revision history for this message
Robert Collins (lifeless) wrote : Re: [Bug 631010] [NEW] ProgrammingError: operator does not exist: text = bytea

The patch looks small enough to CP; we may need to make further
changes to our codebase too though.

Revision history for this message
Henning Eggers (henninge) wrote :

Simply applying the core storm patch (a one-liner) locally did not solve this for me.

Revision history for this message
Henning Eggers (henninge) wrote :

I tried it out and could fix tests by putting "unicode" around parameters in the right places (usually close to storm queries). I stopped doing this when I hit the first decoding errors. :(

It does not look to me like the new storm version will help us in any way rather we need to be fixing our code. But what about the transition? Can psycopg2.2. not be configured to be less strict here, maybe just issue warnings so that we can find the places we need to fix?

Revision history for this message
Curtis Hovey (sinzui) wrote :

I have fallen back to python-psycopg2_2.0.13-2ubuntu2_i386 to ensure I can continue to work. This version could be in lp-deps if we cannot get a storm fix.

Revision history for this message
Gary Poster (gary) wrote :

Foundations' current plan is to put the version Curtis specifies in lp-deps (Maris). Then that will give us breathing room to address the issues Henning describes (Stuart).

Changed in launchpad-foundations:
status: New → Triaged
assignee: nobody → Māris Fogels (mars)
importance: Undecided → High
Māris Fogels (mars)
Changed in launchpad-foundations:
status: Triaged → In Progress
Māris Fogels (mars)
Changed in launchpad-foundations:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
Changed in launchpad-foundations:
milestone: none → 10.10
Curtis Hovey (sinzui)
Changed in launchpad-foundations:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.