Comment 1 for bug 1535164

Revision history for this message
Robert Lyon (robertl-9) wrote :

This looks to be working in postgres but not in mysql.

I wonder if it's due to the triggers having things like:

  UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr

Where the table name is escaped in the postgres way, I wonder if it needs to be like

  UPDATE `usr` SET unread = unread + 1 WHERE id = NEW.usr

Which if true then there will be a bunch of triggers that need fixing up for MySql