id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 12209 Cannot save notify_subscription in PostgreSQL Franz Mayer Jun Omae "When trying to save subscriptions in notification preference panel I am getting an error: **Trac detected an internal error**: {{{ ProgrammingError: operator does not exist: integer = boolean LINE 2: ... WHERE sid='framay' AND authenticated=true ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}} `trac.log` shows the full SQL: {{{ 2015-09-21 15:16:45,165 Trac[build\bdist.win32\egg\trac\db\util] DEBUG: SQL: SELECT id, distribu tor, class FROM notify_subscription WHERE sid=%s AND authenticated=%s 2015-09-21 15:16:45,165 Trac[build\bdist.win32\egg\trac\db\util] DEBUG: args: (u'framay', True) }}} I am using PostgreSQL, where the column `authenticated` is of type `integer`, thus above SQL is not correct, also the insert statement later in the method `Subscription.replace_all`." defect closed normal 1.2 notification 1.1.6 major fixed postgresql Fix not working notification preference panel with PostgreSQL.