[Akonadi] [Bug 326924] Problems when using Postgresql backend database

Cédric Villemain cedric at 2ndQuadrant.com
Mon Nov 4 17:21:13 GMT 2013


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

--- Comment #3 from Cédric Villemain <cedric at 2ndQuadrant.com> ---
ok.
there is an easy way to discover the current status. Check the date type of the
columns ALTER are trying to achieve in your paste.

previous state should be BYTEA. after upgrade should be TEXT.

You can check that with tools like pgadmin3 or psql (easy way is to become
postgres user with sudo, then) :
 $ psql akonadi_db
then 
 # \d flagtable  -- for example

This flagtable content should contains data like:
  4 | \ANSWERED
  5 | \FLAGGED
  6 | \DELETED
  7 | \SEEN
  8 | \DRAFT

*NO* double escape, just a single backslash if the column has already been
'upgraded' to TEXT.
If you have TEXT and double escape, please report.

-- 
You are receiving this mail because:
You are the assignee for the bug.


More information about the Kdepim-bugs mailing list