ERROR: duplicate key value violates unique constraint "ix_messages_messageid"

[pndiku]

This message is in my postgresql logs for every single insert. I've googled and seen that this issue has been raised in the mailing list (and fixed in Baruwa Enterprise Edition) but no fix has trickled down to the Community Edition.

Is it a simple fix that a simple man like myself can do? If so, please point me in the right direction and I'll go for it.

[akissa]

DROP INDEX ix_messages_messageid; CREATE INDEX ix_messages_messageid ON messages(messageid); REINDEX INDEX ix_messages_messageid;

[akissa]

Please test, reopen if you have any issues.

[akissa]

I think there are changes required in the Perl code as well, the patch does not apply cleanly and i don't have time on my hands to shift through it. If you contact me offline i will send you the patch to the which fixes this in the enterprise edition and maybe you can shift through it to make it apply cleanly.

[pndiku]

Works for me