Opened 6 years ago

Closed 4 years ago

#7460 closed defect (fixed)

Wrong schema definition for PostgreSQL

Reported by: mitar Owned by: coderanger
Priority: normal Component: MasterTicketsPlugin
Severity: normal Keywords:
Cc: mitar Trac Release: 0.11


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/", 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)

schema_types.patch (421 bytes) - added by mitar 6 years ago.

Download all attachments as: .zip

Change History (2)

Changed 6 years ago by mitar

comment:1 Changed 4 years ago by rjollos

  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

as closed The owner will remain coderanger.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.