prkhrkat
I have a table in which I have put unique constraints on the combination of two fields. I had also defined this in changeset.
def changeset(asset, attrs) do
asset
|> cast(attrs, @create_attrs)
|> validate_required(@required_attrs)
|> unique_constraint([:serial_number, :organization_id])
end
But I keep getting this error instead of the object {:error, #Ecto.Changeset…} -
Server: localhost:4000 (http)
Request: POST /api/create_asset
** (exit) an exception was raised:
** (Ecto.ConstraintError) constraint error when attempting to insert struct:
* "assets_organization_id_serial_number_index" (unique_constraint)
If you would like to stop this constraint violation from raising an
exception and instead add it as an error to your changeset, please
call `unique_constraint/3` on your changeset with the constraint
`:name` as an option.
Until I found out that order also matters when writing the unique_constraint. It worked when i changed it to -
unique_constraint([:organization_id, :serial_number])
So I just wanted to put it here, so that we can fix this bug in the new release. Would also love to contribute if I’m able to fix it by myself.
Thanks
Trending in Discussions
As the title says, please share what you’ve been up to with Elixir. Whether that’s been learning it, looking into it, making stuff with i...
New
The obligatory hello world thread!
Who are you and where are you from? :stuck_out_tongue:
New
@chrismccord : I just saw the Extract AGENTS.md from Phoenix.new into phx.new generator commit to the phoenix project.
My initial shotgu...
New
I was working on an Ecto migration and I needed a timestamp. So, for the nth time, I looked up the different data types for timestamps, a...
New
Fly’s CEO posted this recently - Turn And Face The Strange · The Fly Blog
It says that Fly is going all-in on sprites, which is a worry ...
New
We’re evaluating API mocking tools for OpenAPI-based projects and would love to hear what other teams are using.
We’re particularly inte...
New
Is there a word for the ~> symbol used in Version strings?
Do you also just call it a Squiggle Arrow™ ?!
New
Other Trending Topics
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve.
They are GUI (Emerge) and State management (S...
New
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
Emily is an Elixir library that runs Nx computations on Apple’s MLX. Install it as the default Nx backend and Nx, defn, Axon, Nx.Serving,...
New
There are three potential reasons for members of this forum to have a look at https://vutuv.de
You are tired or annoyed of LinkedIn.
Yo...
New
Latest Phoenix Threads
Chat & Discussions>Discussions
Latest on Elixir Forum
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
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #ai
- #genstage
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex










First 3 of 3 Posts
sodapopcan
This isn’t a bug, the “order” matters at the database level too. Ecto is using
:org_idand:serial_numberto create the name of the index. Otherwise, the order of compound indexes, at least in postgres, does matter.al2o3cr
The default behavior of
unique_constraintis tripping you up here:organization_idfirst in the index makes sense since Postgres can use partial indexes from the left-hand side.serial_numberfirst in theunique_constraintcall makes sense too, since you likely want the “is already taken” message on the serial number rather than the organization ID.One or the other of these has to change. Either:
unique_constraintthe correct name of the index to use with thename: "assets_organization_id_serial_number_index"optionunique_constraintin the same order as the index (so the name can be automatically generated), then tell it to put the error onserial_numberinstead witherror_keyprkhrkat
Thanks @sodapopcan and @al2o3cr It makes sense.