overcomeoj
What does Ecto.Migration#references() :vaildate do?
In the docs for Ecto Migrations, it has the following description for the validate option you can pass to references.
:validate- Whether or not to validate the foreign key constraint on creation or not. Only available in PostgreSQL, and should be followed by a command to validate the foreign key in a following migration if false.
Does this mean it checks the foreign key constraint on record creation (so every time you make a new row, akin to validate_foreign_constraint() in Changeset?) or on field creation?
Edit: actually now I see that “validate” is set to true on the fk constraint, when I inspect with pgadmin, so I am assuming this act on-insertion and defaults to true, so it acts as you want by default.
Marked As Solved
aseigo
I believe the use-case for this is to not validate the constraint so you can add new fields with such constraints, then populate the new fields with proper data, then enable validation (the “followed by a command to validate…”). This can make things possible (in the case of constraints that would fail until first population) or just faster (running validations costs time, and in a migration you may be able to guarantee the population is correct).
That’s how I’ve always read that, but I could be wrong 
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers.
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.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"