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?
Last Post!
cblavier
Trending in Discussions
Other Trending Topics
Chat & Discussions>Discussions
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #elixirconf-us
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"