rawlinp opened a new pull request #5515: URL: https://github.com/apache/trafficcontrol/pull/5515
## What does this PR (Pull Request) do? In 13.1, the constraint appears to get named 'ip_address_interface_server_fkey' by default, but in 9.6 it appears to get named 'ip_address_interface_fkey' by default. This fixes the migration to change the name to the 9.6 version before altering the constraint in order for upgrades in 13.1 to work. This issue was found when resetting the DB in 13.1. ## Which Traffic Control components are affected by this PR? - Traffic Ops ## What is the best way to verify this PR? On postgres 9.6, run the DB migration (reset, upgrade, down, upgrade), ensure it is successful. Do the same with postgres 13.1. ## If this is a bug fix, what versions of Traffic Control are affected? - basically just master because 13.1 support isn't official yet ## The following criteria are ALL met by this PR - [x] DB migration fix, covered by DB tests - [x] DB migration fix, no docs necessary - [x] not including changelog because this just the start of adding 13.1 support (which will be coming later) - [x] This PR includes any and all required license headers - [x] This PR **DOES NOT FIX A SERIOUS SECURITY VULNERABILITY** (see [the Apache Software Foundation's security guidelines](https://www.apache.org/security/) for details) ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
