Unique constraint violations on tags table
When trying to run a reindex on the tags_tag
table, I get the following message:
postgres=# REINDEX TABLE tags_tag;
ERROR: could not create unique index "tags_tag_name_key"
DETAIL: Key (name)=(robot) is duplicated.
There seem to be many duplicated entries in this table, which means they are slipping through the uniqueness filter. This could cause problems later on if postgres can't build its indexes (see #1843 (closed)).