cblavier
Renaming Postgres index, FK, PK, sequences
Hi everyone,
I wanted to share some code that might be useful for those dealing with table renaming in Ecto migrations. While using Ecto.Migration.rename/2 is straightforward, we’ve encountered an issue: the associated indexes, primary keys, and foreign keys retain their original naming conventions, which can lead to confusion.
To address this, our team developed some helper functions that streamline the renaming process and ensure that all related database objects are renamed consistently.
A bonus is that you get rollback for free.
Feel free to leave any comments or suggestions!
Hope this helps!
Most Liked
sodapopcan
This is great, thank you! I’ve faced this several times recently and it’s a slog. It feels like this could be in Ecto. Are there some edge cases that would make this a maintenance burden?
Popular in Discussions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"