Forum OpenACS Q&A: Response to "insert a duplicate key into unique index referer_log_pkey" error

Sounds like the "where" clause guarding against the duplicate insert is failing for you.  Have you gone into psql to see if a row with those values exists?  If so, could you dig a bit deeper in an effort to figure out why the query's failing?