When I try to insert all, I get this error:
15:00:21.443 [error] Task #PID<0.2505.0> started from #PID<0.2504.0> terminating
** (Postgrex.Error) ERROR 42P10 (invalid_column_reference): there is no unique or exclusion constraint matching the ON CONFLICT specification
(ecto) lib/ecto/adapters/sql.ex:195: Ecto.Adapters.SQL.query!/5
(ecto) lib/ecto/adapters/postgres.ex:86: Ecto.Adapters.Postgres.insert_all/7
(ecto) lib/ecto/repo/schema.ex:55: Ecto.Repo.Schema.do_insert_all/7
(trackware) web/controllers/csvs_controller.ex:413: Trackware.CsvsController.write_ecto_rows_schools/4
(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
Function: &Trackware.CsvsController.chunk_handler_fn/6
Args: [[nil, ["1", "suhaib Ali shakra", "(872) 672-9695"], nil, ["2", "Julia Ali shakra", "(626) 748-9460"], nil, ["3", "Carlos Ali shakra", "(608) 685-8618"], ["4", "Mike Ali shakra", "(964) 469-6467"], nil, ["5", "Rachel Ali shakra", "(382) 722-3568"], nil, ["6", "Johanna Ali shakra", "(315) 677-9912"], nil, ["7", "Peter Ali shakra", "(448) 358-4829"], nil, ["8", "Joseph Ali shakra", "(510) 540-3148"], nil, ["9", "Jeremy Ali shakra", "(211) 712-4122"], nil, ["10", "Jedfdr Ali shakra", "(760) 580-1720"], nil], "process:1494255621439525", ["0", "driver_name", "driver_mobile"], "schools", 3, "drivers"]
Here is how I insert records:
{inserted_count, inserted_records}= Repo.insert_all(Driver, ecto_rows, on_conflict: :nothing, returning: [:driver_name], conflict_target: :driver_name)
How can I debug this error?
