id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 2164 DB error when submitting Custom Query using custom fields against Postgres abudinsz@… Christopher Lenz "I added a single custom field in trac.ini called ""customer"". When attempting to submit a Custom Query where the ""customer"" field is used as a condition I get a DB error. This problem occured (with slightly different behavior) by using either of the two recommended postgresql python bindings. Trac.ini (excerpt): {{{ [ticket-custom] customer = select customer.label = Customer customer.options = none|Company1|Company2|Company3|Company4 customer.value = 0 }}} Environment: * PostgreSQL - 7.4.8 * Python - 2.3.5 * Apache - 2.0.46 * Trac - 0.9b2 (also happened with 0.9b1) {{{ Traceback: Traceback (most recent call last): File ""/opt/trac/lib/python2.3/site-packages/trac/web/modpython_frontend.py"", line 206, in handler dispatch_request(mpr.path_info, mpr, env) File ""/opt/trac/lib/python2.3/site-packages/trac/web/main.py"", line 139, in dispatch_request dispatcher.dispatch(req) File ""/opt/trac/lib/python2.3/site-packages/trac/web/main.py"", line 107, in dispatch resp = chosen_handler.process_request(req) File ""/opt/trac/lib/python2.3/site-packages/trac/ticket/query.py"", line 393, in process_request self.display_html(req, query) File ""/opt/trac/lib/python2.3/site-packages/trac/ticket/query.py"", line 507, in display_html tickets = query.execute(db) File ""/opt/trac/lib/python2.3/site-packages/trac/ticket/query.py"", line 140, in execute cursor.execute(sql) ProgrammingError: ERROR: relation reference ""customer"" cannot be used in an expression SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,customer.value AS customer FROM ticket AS t LEFT OUTER JOIN ticket_custom AS customer ON (id=customer.ticket AND customer.name='customer') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority) WHERE COALESCE(t.status,'') IN ('new','assigned','reopened') AND COALESCE(customer,'')='' AND COALESCE(t.owner,'')!='myuser' ORDER BY COALESCE(t.priority,'')='',priority.value,t.id }}}" defect closed high 0.9 ticket system 0.9b2 critical fixed postgresql, custom, query