On Wednesday March 3 2010 11:20:26 Michael Monnerie wrote: > We have AWL in PostgreSQL, the extended schema for SA 3.3: > We get a lot of > "INSERT: duplicate key violates unique contraint »awl_pkey«" > messages, is that normal? Seems SA tries to insert without checking if > the record exists already. What can we do?
Yes, this is correct. After a failed INSERT, awl does an UPDATE. The change was done to avoid race condition in previous code. See https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6203#c12 Mark