id summary reporter owner description type status priority component severity resolution keywords cc release 2764 Sporadic error on Postgres Peter Robert Corsaro "It does not seem to impact normal operation, but I'm gettin tons of error messages in Postgres logs: {{{ HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. STATEMENT: SELECT value FROM session_attribute WHERE sid='jbrink' AND authenticated=true AND name='announcer_email_format_ticket' ERROR: current transaction is aborted, commands ignored until end of transaction block STATEMENT: SELECT DISTINCT s.sid, n.value, e.value FROM session AS s LEFT JOIN session_attribute AS n ON (n.sid=s.sid and n.authenticated=1 AND n.name = 'name') LEFT JOIN session_attribute AS e ON (e.sid=s.sid AND e.authenticated=1 AND e.name = 'email') WHERE s.authenticated=1 ORDER BY s.sid }}} I cant pinpoint where this happens - tried browsing around Trac but couldnt trigger it. Obviously the cause is 'authenticated=true' clause, should have been 'authenticated=1'" defect closed normal AnnouncerPlugin minor fixed 0.11