[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"

Christophe Giboudeaux cgiboudeaux at gmx.com
Tue Sep 13 10:33:53 BST 2011


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


Christophe Giboudeaux <cgiboudeaux at gmx.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDSINFO                   |NEW
         Resolution|WAITINGFORINFO              |




--- Comment #7 from Christophe Giboudeaux <cgiboudeaux gmx com>  2011-09-13 09:33:53 ---
Bah, after switching again to postgres, I see a similar error again

Error during executing query "INSERT INTO CollectionTable (remoteId,
remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1,
:2, :3, :4, :5) RETURNING id" :  "ERROR:  duplicate key value violates unique
constraint "collectiontable_parentandnameindex"
DÉTAIL : Key (parentid, name)=(2, \x7472617368) already exists.
QPSQL: Unable to create query"
Error during insertion into table "CollectionTable" "ERROR:  duplicate key
value violates unique constraint "collectiontable_parentandnameindex"
DÉTAIL : Key (parentid, name)=(2, \x7472617368) already exists.
QPSQL: Unable to create query"

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


More information about the Kdepim-bugs mailing list