Hello Arnt, Am Fri, 18 Jul 2014 10:53:35 +0200 schrieb Arnt Gulbrandsen <[email protected]>: > Axel Rau ran into this, and fixed it manually in his database. I > think his problem was something like having two aliases that differed > only in case. Do you have that?
These were actually exact duplicates, the casing did not differ. > The code in the stepTo96() function in db/schema.cpp is meant > deduplicate, but clearly it doesn't quite work. Can you try to run > that query sequence by hand (in a transaction, of course) and having > a look at what it misses or where it fails? A patch would be > appreciated. The culprit wasn't the index being created (addresses_ldn_key) but the index to be dropped (addresses_nld_key). For some reasons this index was not present in our database (which also explains the dupes) and the code raised an error in "drop index addresses_nld_key". Just adding "if exists" fixed this problem here. I had some more errors in changing column types, but these were due to some of our custom triggers referencing these columns. Now the schema upgrade is done, thanks! Markus
