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
I want to open this thread for you all to discuss and help those who really like Ash but are still hesitant to use it in a real project. ...
New
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
I’m posting this in response to Jose’s recent tweet (Cr. link) :
People are sleeping on Elixir for a coding harness:
Hot-code swappi...
New
Hello,
I wrote Stop My Hand, a Scattergories-like web application using Phoenix/LiveView as my learning project for Elixir (after readin...
New
It would be helpful to have a list of companies worldwide that hire engineers without prior experience in Elixir. Often, it can be quite ...
New
Anyone running long-lived stateful processes on BEAM? We’re building an AI agent runtime and would love to compare notes.
We’re a small ...
New
Other Trending Topics
Hobbes is a low-level distributed database for the Elixir programming language.
Hobbes provides a simple, safe, and scalable storage lay...
New
Hi there! We created Gust: A task orchestrator inspired by Airflow.
For those who have never heard about Aiflow, it’s a Python-based wor...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
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
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming











Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
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.