I tried to insert records as:
Repo.insert_all(MyApp.Node, db_records, on_conflict: :nothing)
But I got this error:
[error] Task #PID<0.1547.0> started from #PID<0.1546.0> terminating
** (Postgrex.Error) ERROR (unique_violation): duplicate key value violates unique constraint "nodes_unique_name_uindex"
table: nodes
constraint: nodes_unique_name_uindex
Key (unique_name)=(Helen) already exists.
(ecto) lib/ecto/adapters/sql.ex:187: Ecto.Adapters.SQL.query!/5
(ecto) lib/ecto/adapters/sql.ex:375: Ecto.Adapters.SQL.insert_all/8
(ecto) lib/ecto/repo/schema.ex:48: Ecto.Repo.Schema.do_insert_all/6
(trackware) web/controllers/csvs_controller.ex:81: Trackware.CsvsController.write_csv_records/1
(elixir) lib/task/supervised.ex:85: Task.Supervised.do_apply/2
(elixir) lib/task/supervised.ex:36: Task.Supervised.reply/5
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
So, shouldn’t the on_conflict: :nothing
suppress such error?