Hi,
I've tried to use postgresql as database for akonadi.
I've created user, base an started akonadi.
Table was created but i think column 'isvirtual' in table 'collectiontable' has wrong type, when akonadi start:
Sql error: ERROR:  column "isvirtual" is of type boolean but expression is of type integer
LIGNE 1 : ...sourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)
                                                                       ^
ASTUCE : You will need to rewrite or cast the expression.
QPSQL: Unable to create query
Query: INSERT INTO CollectionTable (resourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)" 
Unable to initialize database. 
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x454584]
1: akonadiserver() [0x4548c1]
2: /usr/lib/libc.so.6(+0x35050) [0x7f852cfb9050]
3: /usr/lib/libc.so.6(gsignal+0x35) [0x7f852cfb8fd5]
4: /usr/lib/libc.so.6(abort+0x148) [0x7f852cfba458]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f852ea70414]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x45663b]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f852eb0ab54]
8: /usr/lib/libQtCore.so.4(+0x1167ff) [0x7f852eb157ff]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f852eb1ddfb]
10: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5e5) [0x4586e5]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x459897]
12: akonadiserver(main+0x1a0) [0x44d170]
13: /usr/lib/libc.so.6(__libc_start_main+0xf5) [0x7f852cfa5725]
14: akonadiserver() [0x44d971]
]

I've tried to manually change type with psql but then:

Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, resourceId, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9) RETURNING id" :  "ERROR:  parameter $10 of type boolean cannot be coerced to the expected type smallint


Reproducible: Always

Steps to Reproduce:
1. create pgql base with user. Configure akonadi to use it
2. start akonadi
3.
Actual Results:  
in akonadi logs:
Sql error: ERROR:  column "isvirtual" is of type boolean but expression is of type integer
LIGNE 1 : ...sourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)
                                                                       ^
ASTUCE : You will need to rewrite or cast the expression.
QPSQL: Unable to create query
Query: INSERT INTO CollectionTable (resourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)" 
Unable to initialize database. 
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x454584]
1: akonadiserver() [0x4548c1]
2: /usr/lib/libc.so.6(+0x35050) [0x7f852cfb9050]
3: /usr/lib/libc.so.6(gsignal+0x35) [0x7f852cfb8fd5]
4: /usr/lib/libc.so.6(abort+0x148) [0x7f852cfba458]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f852ea70414]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x45663b]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f852eb0ab54]
8: /usr/lib/libQtCore.so.4(+0x1167ff) [0x7f852eb157ff]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f852eb1ddfb]
10: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5e5) [0x4586e5]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x459897]
12: akonadiserver(main+0x1a0) [0x44d170]
13: /usr/lib/libc.so.6(__libc_start_main+0xf5) [0x7f852cfa5725]
14: akonadiserver() [0x44d971]
]

Expected Results:  
akonadi should start