Modify ↓
Opened 14 years ago
Closed 12 years ago
#7460 closed defect (fixed)
Wrong schema definition for PostgreSQL
Reported by: | Mitar | Owned by: | Noah Kantrowitz |
---|---|---|---|
Priority: | normal | Component: | MasterTicketsPlugin |
Severity: | normal | Keywords: | |
Cc: | Mitar | Trac Release: | 0.11 |
Description
Schema defintion for mastertickets
table is not precise and so plugin fails on PostgreSQL with:
ProgrammingError: operator does not exist: text = integer LINE 1: SELECT dest FROM mastertickets WHERE source=32 ORDER BY dest ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
This select query is in:
File "/usr/lib/pymodules/python2.5/mastertickets/model.py", line 22, in __init__
The problem is that columns are not defined with integer type. I am attaching a patch which fixes this.
Attachments (1)
Change History (2)
Changed 14 years ago by
Attachment: | schema_types.patch added |
---|
comment:1 Changed 12 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
This was fixed in ae03a927c629cc1df790b261202e2efea1da1805.