[Kde-pim] Review Request: Postgresql support in akonadi

[igorto]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://reviewboard.kde.org/r/797/#review1406
-----------------------------------------------------------


I was testing it in PostgreSQL 8.3 and i just tried to use the imap resource and i received these warnings:
[akonadiserver] Insert from DataStore::appendPimItem                            
[akonadiserver] WARNING:  nonstandard use of \\ in a string literal             
[akonadiserver] LINE 1: EXECUTE qpsqlpstmt_248 (30, 'PLD:ENVELOPE', '("Fri, 26 Jun 2...     


[akonadiserver] WARNING:  nonstandard use of \\ in a string literal             
[akonadiserver] LINE 1: EXECUTE qpsqlpstmt_1d4 (7, '\\Seen')                    
[akonadiserver] ^                                                               
[akonadiserver] HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.


But with these warnings the imap resource works fine, but when i try to delete the imap resource i received the error message in database:

Application '/usr/local/bin/akonadi_imap_resource' exited normally...           
[akonadiserver] Error during executing query "DELETE FROM CollectionTable WHERE ( id = :0 )" :  "ERROR:  update or delete on table "collectiontable" violates foreign key constraint "collectiontable_parentid_fkey" on table "collectiontable" 
[akonadiserver] DETAIL:  Key (id)=(2) is still referenced from table "collectiontable".      

- igorto


On 2009-06-19 08:04:14, jgoday wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> http://reviewboard.kde.org/r/797/
> -----------------------------------------------------------
> 
> (Updated 2009-06-19 08:04:14)
> 
> 
> Review request for KDE PIM.
> 
> 
> Summary
> -------
> 
> Postgresql support in akonadi server/Storage
> 
> 
> Diffs
> -----
> 
>   /trunk/kdesupport/akonadi/server/src/handler/aklist.cpp 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/akonadidb.xml 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/akonadidb.xsd 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/dbinitializer.cpp 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/entities-source.xsl 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/entities.xsl 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/entity.h 983958 
>   /trunk/kdesupport/akonadi/server/src/storage/querybuilder.cpp 983958 
>   /trunk/kdesupport/akonadi/server/src/tests/CMakeLists.txt 983958 
> 
> Diff: http://reviewboard.kde.org/r/797/diff
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> jgoday
> 
>

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/