After update 6002 the schema module reports a mismatch. The attached patch fixed this for me.
I'm running postgresql 8.4
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | 562202_cart_id_index.patch | 1.57 KB | Island Usurper |
| #4 | 562202_cart_id_index.patch | 1.3 KB | Island Usurper |
| #1 | uc_cart_products.patch | 601 bytes | wedge |
| uc_cart_products.diff | 539 bytes | wedge |
Comments
Comment #1
wedge commentedOops, missed that db_change_field() removes the index. New path attached.
Comment #2
Island Usurper commentedSince it's really only the index that is not consistent, I think this update function can just add it instead of doing a full table alter. There doesn't seem to be a good way to avoid duplicate index errors, though.
However, your patch still doesn't actually add the index. You have a closing parenthesis in the wrong place.
Comment #3
Island Usurper commentedComment #4
Island Usurper commentedIt's got some ugly error suppression, but that's because there isn't an easy way to tell if the index already exists or not. I suppose the @ operator would be cleaner, but I don't want to suppress *all* possible errors.
Comment #5
Island Usurper commentedOf course, Postgres has a different error message to be suppressed. Two of them, oddly enough. Now the patch works on MySQL and Postgres, so it's been committed.