oid = numeric operator does not exist db error

Bug #230796 reported by Mathieu Fenniak
2
Affects Status Importance Assigned to Milestone
pg8000
Status tracked in Trunk
Trunk
Fix Released
Medium
Mathieu Fenniak

Bug Description

cursor.execute("SELECT attname FROM pg_attribute WHERE attrelid = (SELECT indexrelid FROM pg_index i WHERE i.indrelid = %(table)s", {"table": 50319})

causes DB error "operator does not exist: oid = numeric", probably because the table parameter is being bound as a numeric field. It may be possible to bind int->int, long->long, decimal->numeric to fix this issue.

Related branches

Changed in pg8000:
assignee: nobody → mfenniak
importance: Undecided → Medium
milestone: none → sqlalchemy
status: New → Confirmed
Changed in pg8000:
status: Confirmed → Fix Committed
Revision history for this message
Mathieu Fenniak (mfenniak) wrote :

Fix released in pg8000 v1.05.

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.