Modify ↓
Opened 3 years ago
Closed 8 months ago
#7460 closed defect (fixed)
Wrong schema definition for PostgreSQL
| Reported by: | mitar | Owned by: | coderanger |
|---|---|---|---|
| Priority: | normal | Component: | MasterTicketsPlugin |
| Severity: | normal | Keywords: | |
| Cc: | mmitar@… | 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 3 years ago by mitar
comment:1 Changed 8 months ago by rjollos
- Resolution set to fixed
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.


This was fixed in ae03a927c629cc1df790b261202e2efea1da1805.