https://bugs.kde.org/show_bug.cgi?id=312460
--- Comment #47 from Christian Mollekopf <mollek...@kolabsys.com> --- (In reply to comment #40) > It seems that I found the reason at least for postgresql backend. > > There are a lot of errors in akonadiserver.error log like > > cannot execute "SELECT id, name FROM FlagTable WHERE ( name = ( :0 ) )" query > where :0 is '\SEEN' > > Indeed > akonadi=> SELECT id, name FROM FlagTable WHERE ( name = ( '\SEEN' ) ); > returns > bytea > ERROR: incorrect syntax for bytea type. > > However '\\SEEN' works fine > akonadi=> SELECT id, name FROM FlagTable WHERE ( name = ( '\\SEEN' ) ); > id | name > ----+-------------- > 7 | \x5c5345454e > > Attribute 'standard_conforming_strings' was set 'on' in postgresql.conf > > > I found a hack in changing type of FlagTable.name column to text type. > > So there are tow way to fix the bug: > 1. change type of the FlagTable.name column > 2. Escape all '\' characters by additional backslash in queries. I don't think this problem is related but it sounds like a genuine bug. Could you please open a separate bugreport including your patch? Thanks -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs