id summary reporter owner description type status priority component severity resolution keywords cc release 2658 [Patch] Type Casts in Postgresl 8.3 victorhg@… Noah Kantrowitz " Hello, I've been trying to use the MasterTicketsPlugin with postgresql 8.3. There are some issues with type checking (PSQGL has a strong type checking mechanism): model.py {{{ cursor.execute('SELECT dest FROM mastertickets WHERE source=%s ORDER BY dest', (self.tkt.id,)) }}} should be {{{ cursor.execute('SELECT dest FROM mastertickets WHERE source='%s' ORDER BY dest', (self.tkt.id,)) }}} Am i right?? I'm receiveing the psql error: {{{ 2008-02-29 11:38:17 BRT HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. 2008-02-29 11:38:17 BRT COMMAND: SELECT dest FROM mastertickets WHERE source=1 ORDER BY dest }}} The [http://trac.edgewall.org/wiki/TracInstall TracInstall] comes with the follwing alert, related with the problem described above:[[br]] '' '''Warning:''' PostgreSQL 8.3 uses a strict type checking mechanism. To use Trac with the 8.3 Version of PostgreSQL, you will need trac-0.11 or later.'' thanks" defect closed highest MasterTicketsPlugin blocker fixed theyranos@… shanec@… nulleke76@… Dag Viggo Lokøen carlos@… bernd.tegge@… kmacinni@… brad-trachacks@… kuehn@… 0.11