[Bug 252120] Akonadi fails to start with postgres backend. Possibly due to wrong escape '\\ANSWERED'

[David Blewett]

https://bugs.kde.org/show_bug.cgi?id=252120





--- Comment #3 from David Blewett <david dawninglight net>  2010-12-01 05:09:37 ---
Unfortunately, you can't start Akonadi back up later on then however. It seems
that Akonadi is not detecting the created tables correctly. PostgreSQL
automatically folds unquoted table/column identifiers to lowercase. So,
SchemaVersionTable is actually created as schemaversiontable. If you want the
table to be created with mixed case you have to use "SchemaVersionTable" in the
CREATE TABLE command.

http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

"Quoting an identifier also makes it case-sensitive, whereas unquoted names are
always folded to lower case. For example, the identifiers FOO, foo, and "foo"
are considered the same by PostgreSQL, but "Foo" and "FOO" are different from
these three and each other. (The folding of unquoted names to lower case in
PostgreSQL is incompatible with the SQL standard, which says that unquoted
names should be folded to upper case. Thus, foo should be equivalent to "FOO"
not "foo" according to the standard. If you want to write portable applications
you are advised to always quote a particular name or never quote it.)"

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.