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

[Christophe Giboudeaux]

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





--- Comment #3 from Christophe Giboudeaux <cgiboudeaux gmail com>  2010-06-20 23:48:46 ---
Here's the full query that the server is running: 

[akonadiserver] Executing query "INSERT INTO CollectionTable (remoteId,
remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1,
:2, :3, :4, :5) RETURNING id"
[akonadiserver] ":0" QVariant(QString, "/Junk")
[akonadiserver] ":1" QVariant(QString, "")
[akonadiserver] ":2" QVariant(QString, "Junk")
[akonadiserver] ":3" QVariant(qlonglong, 5)
[akonadiserver] ":4" QVariant(qlonglong, 3)
[akonadiserver] ":5" QVariant(bool, true)
[akonadiserver] 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"
[akonadiserver] QPSQL: Unable to create query"
[akonadiserver] Error during insertion into table "CollectionTable" "ERROR: 
duplicate key value violates unique constraint
"collectiontable_parentandnameindex"
[akonadiserver] QPSQL: Unable to create query"
[akonadiserver] Unable to free statement: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
[akonadiserver]

-- 
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.