[Akonadi] [Bug 328325] New: akonadi postgresql backend runs incorrect alter table query

[Vincent de Phily]

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

            Bug ID: 328325
           Summary: akonadi postgresql backend runs incorrect alter table
                    query
    Classification: Unclassified
           Product: Akonadi
           Version: 1.10.3
          Platform: Gentoo Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: kdepim-bugs at kde.org
          Reporter: moltonel at gmail.com

Akonadi pg backend runs erroneous "alter table" queries at startup. I tries to
convert a colum to text, but it is already of type text. The pg function
convert_from() requires a bytea as first argument.

Maybe it worked with older versions of postgres, which had an implicit text to
bytea cast.

Incidentally, it is strange that akonadi would need to run any "alter table"
query on a freshly-created database.

Reproducible: Always

Steps to Reproduce:
1. start postgres 9.2 server
2. createdb akonadi
3. configure pg backend using akondiconsole
4. restart akonadi server
5. click "test..." in akonadiconsole 
Actual Results:  
Current Akonadi server error log found:


DBUpdater: query error: "ERROR:  function convert_from(text, unknown) does not
exist
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
(42883) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER remoteId TYPE text USING
convert_from(remoteId,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
....
Failed to commit transaction for database update.

Expected Results:  
No error.

Using PG 9.2, akonadi 1.10.3, qtsql 4.8.5

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