Hi there, I'm trying to upgrade an exisiting AOX installation (it says 3.1.4) to version 3.2.0 (build from git tag on Debian Wheezy).
On schema upgrade I get the following errors: # /opt/archiveopteryx/bin/aox upgrade schema aox: Upgrading schema from revision 95 to revision 97. aox: 95-96: Convert addresses to use CITEXT. If this fails, please run "CREATE EXTENSION citext;" as the postgres superuser and then rerun aox upgrade schema. aox: Operation would create two identical addresses (addresses_nld_key) aox: 96-97: Dropping aox views. aox: Warning: db-user is the same as db-owner aox: Checking database, adjusting privileges. aox: The schema could not be upgraded to revision 97. aox: The schema could not be upgraded to revision 97. aox: Fatal error. Exiting. I checked the unique index to be created (addresses_nld_key) and there are indeed duplicates in the database. Is there any procedure to clean up the dupes? addresses.id is referenced from multiple other tables, fixing this manually would be a significant amount of work (there isn't only one dupe in our database). Thanks in advance, Markus
