darinwilson / music_db_workshop Goto Github PK

...

15:50:09.435 [debug] QUERY ERROR db=0.0ms queue=6.3ms
INSERT INTO "genres" ("name","wiki_tag","inserted_at","updated_at") VALUES ($1,$2,$3,$4) ON CONFLICT ("name") DO UPDATE SET "name" = EXCLUDED."name","wiki_tag" = EXCLUDED."wiki_tag","inserted_at" = EXCLUDED."inserted_at","updated_at" = EXCLUDED."updated_at" RETURNING "id" ["jazz", "Jazz", ~N[2019-08-22 19:50:09], ~N[2019-08-22 19:50:09]]
** (Postgrex.Error) ERROR 42601 (syntax_error) syntax error at or near "ON"

    query: INSERT INTO "genres" ("name","wiki_tag","inserted_at","updated_at") VALUES ($1,$2,$3,$4) ON CONFLICT ("name") DO UPDATE SET "name" = EXCLUDED."name","wiki_tag" = EXCLUDED."wiki_tag","inserted_at" = EXCLUDED."inserted_at","updated_at" = EXCLUDED."updated_at" RETURNING "id"
    (ecto_sql) lib/ecto/adapters/sql.ex:621: Ecto.Adapters.SQL.raise_sql_call_error/1
    (ecto) lib/ecto/repo/schema.ex:649: Ecto.Repo.Schema.apply/4
    (ecto) lib/ecto/repo/schema.ex:262: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4
    (ecto) lib/ecto/repo/schema.ex:164: Ecto.Repo.Schema.insert!/4
    priv/repo/seeds.exs:4: (file)
Unable to setup the database - please check the settings in config/dev.exs

✘-1 ~/@code/music_db_workshop [master ↑·1|…1] 
(ins)15:50 $ psql -d postgres
psql (9.4.5)
Type "help" for help.

(ins)postgres=# SELECT version();
                                                   version                                                    
--------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.4.5 on x86_64-apple-darwin15.0.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit
(1 row)