[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 #8 from Christophe Giboudeaux <cgiboudeaux gmx com>  2011-09-13 09:54:24 ---
and the query causing that is :

Executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name,
parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5)
RETURNING id"
":0" QVariant(QString, "trash")
":1" QVariant(QString, "")
":2" QVariant(QString, "trash")
":3" QVariant(qlonglong, 2)
":4" QVariant(qlonglong, 2)
":5" QVariant(bool, true)


the resource with id=2 is the maildir one and

SELECT * FROM collectiontable WHERE name='trash' AND resourceId=2 already 
returns a row :
id=7
remoteid=""
remoterevision=""
name=trash
parentid=2
resourceid=2
[...]
cachepolicyinherit=true

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