id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 3677,Database operations fail with PostgreSQL 8.3,david@…,Steffen Hoffmann,"As of PostgreSQL, many automatic casts to text were removed. See the [http://www.postgresql.org/docs/8.3/static/release-8-3.html#AEN86013 release notes]. A symptom is the following error I received: {{{ ProgrammingError: operator does not exist: text = integer LINE 1: DELETE FROM tags WHERE tagspace=E'screenshots' AND name=3 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}} Traceback: {{{ Most recent call last: * File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py"", line 423, in _dispatch_request Code fragment: 418. try: 419. if not env and env_error: 420. raise HTTPInternalError(env_error) 421. try: 422. dispatcher = RequestDispatcher(env) 423. dispatcher.dispatch(req) 424. except RequestDone: 425. pass 426. resp = req._response or [] 427. 428. except HTTPException, e: Local variables: Name Value after [u' except RequestDone:', u' pass', u' resp = ... before [u' try:', u' if not env and env_error:', u' raise ... dispatcher e ProgrammingError(""operator does not exist: text = integer\nLINE 1: DELETE ... env env_error None exc_info (, ProgrammingError(""operator does not ... filename '/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.p ... frames [{'function': '_dispatch_request', 'lines_before': [u' try:', u' ... has_admin True line u' dispatcher.dispatch(req)' lineno 422 message u""ProgrammingError: operator does not exist: text = integer\nLINE 1: ... req resp [] tb tb_hide None traceback 'Traceback (most recent call last):\n File ... * File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py"", line 197, in dispatch Code fragment: 192. req.args.get('__FORM_TOKEN') != req.form_token: 193. raise HTTPBadRequest('Missing or invalid form token. ' 194. 'Do you have cookies enabled?') 195. 196. # Process the request and render the template 197. resp = chosen_handler.process_request(req) 198. if resp: 199. if len(resp) == 2: # Clearsilver 200. chrome.populate_hdf(req) 201. template, content_type = \ 202. self._post_process_request(req, *resp) Local variables: Name Value chosen_handler chrome ctype 'multipart/form-data' err (, ProgrammingError(""operator does not ... handler options {'boundary': '---------------------------1687091515871393671656955613'} req self * File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/core.py"", line 127, in process_request Local variables: Name Value actions ['post-add', 'view'] context > db req self * File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/core.py"", line 338, in _do_actions Local variables: Name Value action 'post-add' actions ['post-add', 'view'] api components [] context > ext u'.jpg' file ', mode 'w+b' at 0x809429d50> filename u'signet.jpg' filepath u'/usr/local/svn/trac/screenshots/3/signet-1024x721.jpg' image listener name u'signet' out_file result <_sre.SRE_Match object at 0x80951c8b0> screenshot {'description': u'', 'author': u'davidb', 'components': [], 'tags': u'', ... self versions [] * File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/tags.py"", line 42, in screenshot_created Local variables: Name Value req resource screenshot {'description': u'', 'author': u'davidb', 'components': [], 'tags': u'', ... self tag_system * File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tractags/api.py"", line 226, in delete_tags Local variables: Name Value provider req resource self tags None * File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tractags/api.py"", line 150, in remove_resource_tags Local variables: Name Value cursor db req resource self * File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py"", line 50, in execute Code fragment: 45. def execute(self, sql, args=None): 46. # -- In case of SQL errors, uncomment the following 'print' statements 47. # print 'execute', repr(sql) 48. if args: 49. # print repr(args) 50. return self.cursor.execute(sql_escape_percent(sql), args) 51. return self.cursor.execute(sql) 52. 53. def executemany(self, sql, args=None): 54. # print 'executemany', repr(sql) 55. if args: Local variables: Name Value args ('screenshots', 3) self sql 'DELETE FROM tags WHERE tagspace=%s AND name=%s' * File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py"", line 50, in execute Code fragment: 45. def execute(self, sql, args=None): 46. # -- In case of SQL errors, uncomment the following 'print' statements 47. # print 'execute', repr(sql) 48. if args: 49. # print repr(args) 50. return self.cursor.execute(sql_escape_percent(sql), args) 51. return self.cursor.execute(sql) 52. 53. def executemany(self, sql, args=None): 54. # print 'executemany', repr(sql) 55. if args: Local variables: Name Value args ('screenshots', 3) self sql 'DELETE FROM tags WHERE tagspace=%s AND name=%s' File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py"", line 423, in _dispatch_request dispatcher.dispatch(req) File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py"", line 197, in dispatch resp = chosen_handler.process_request(req) File ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/core.py"", line 127, in process_requestFile ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/core.py"", line 338, in _do_actionsFile ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tracscreenshots/tags.py"", line 42, in screenshot_createdFile ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tractags/api.py"", line 226, in delete_tagsFile ""build/bdist.freebsd-7.0-RELEASE-amd64/egg/tractags/api.py"", line 150, in remove_resource_tagsFile ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py"", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""/usr/local/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py"", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) }}} System Information: {{{ User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.1) Gecko/2008072820 Firefox/3.0.1 Trac: 0.11 Python: 2.5.2 (r252:60911, Jun 11 2008, 10:11:18) [GCC 4.2.1 20070719 [FreeBSD]] setuptools: 0.6c8 psycopg2: 2.0.7 Genshi: 0.5.1 Pygments: 0.11.1 Subversion: 1.5.1 (r32289) SilverCity: 0.9.7 jQuery: 1.2.3 }}}",defect,closed,normal,TagsPlugin,normal,fixed,postgresql text cast,Ryan J Ollos Michael Renzmann,0.11