{"action":"created","issue":{"url":"https://api.github.com/repos/cayleygraph/cayley/issues/478","repository_url":"https://api.github.com/repos/cayleygraph/cayley","labels_url":"https://api.github.com/repos/cayleygraph/cayley/issues/478/labels{/name}","comments_url":"https://api.github.com/repos/cayleygraph/cayley/issues/478/comments","events_url":"https://api.github.com/repos/cayleygraph/cayley/issues/478/events","html_url":"https://github.com/cayleygraph/cayley/issues/478","id":178316145,"number":478,"title":"Writing to Postgres backend doesn't working","user":{"login":"maximmi","id":1146619,"avatar_url":"https://avatars.githubusercontent.com/u/1146619?v=3","gravatar_id":"","url":"https://api.github.com/users/maximmi","html_url":"https://github.com/maximmi","followers_url":"https://api.github.com/users/maximmi/followers","following_url":"https://api.github.com/users/maximmi/following{/other_user}","gists_url":"https://api.github.com/users/maximmi/gists{/gist_id}","starred_url":"https://api.github.com/users/maximmi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maximmi/subscriptions","organizations_url":"https://api.github.com/users/maximmi/orgs","repos_url":"https://api.github.com/users/maximmi/repos","events_url":"https://api.github.com/users/maximmi/events{/privacy}","received_events_url":"https://api.github.com/users/maximmi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-21T11:11:37Z","updated_at":"2016-09-21T11:20:49Z","closed_at":null,"body":"Hi there\r\n\r\nI am trying to repeat simple getting started procedure, but failed on loading data into DB:\r\n\r\n```\r\n17:05 $ ./cayley init --config=cayley.cfg.overview --alsologtostderr\r\nI0921 17:06:01.708930   82728 cayley.go:179] Setting GOMAXPROCS to 8\r\n✔ ~/cayley/src/github.com/cayleygraph/cayley [master|…1]\r\n17:06 $ ./cayley load --config=cayley.cfg.overview --quads=data/testdata.nq --alsologtostderr\r\nI0921 17:06:06.561417   82765 cayley.go:179] Setting GOMAXPROCS to 8\r\nI0921 17:06:06.561707   82765 db.go:52] Opening quad store \"sql\" at postgres://postgres:12345@127.0.0.1:5432/cayley?sslmode=disable\r\nI0921 17:06:06.565981   82765 db.go:62] Opening replication method \"single\"\r\nE0921 17:06:06.569253   82765 cayley.go:294] db: failed to load data: pq: syntax error at or near \"ON\"\r\n```\r\n\r\nWhile trying to add something using REPL there is no errors, but nothing gets saved into DB.\r\n\r\n```\r\n17:06 $ ./cayley repl --config=cayley.cfg.overview --alsologtostderr\r\nI0921 17:09:43.946738   82846 cayley.go:179] Setting GOMAXPROCS to 8\r\nI0921 17:09:43.947390   82846 db.go:52] Opening quad store \"sql\" at postgres://postgres:12345@127.0.0.1:5432/cayley?sslmode=disable\r\nI0921 17:09:43.955467   82846 db.go:62] Opening replication method \"single\"\r\ncreating new history file: \".cayley_history\"\r\ncayley> :a bob follow ben .\r\ncayley> g.V().All()\r\n\r\n=> <nil>\r\n-----------\r\n1 Result\r\nElapsed time: 2.619388 ms\r\n\r\ncayley> g.V(\"bob\")\r\n\r\n=> &{[{is 0x491500 0x491600 []}] <nil> {<nil>}}\r\n-----------\r\n1 Result\r\nElapsed time: 0.151153 ms\r\n\r\ncayley>\r\n```\r\n\r\nhere is my config:\r\n\r\n```\r\n17:11 $ cat cayley.cfg.overview\r\n{\r\n\"database\": \"sql\",\r\n\"db_path\": \"postgres://postgres:12345@127.0.0.1:5432/cayley?sslmode=disable\",\r\n\"read_only\": false\r\n}\r\n```\r\n\r\nThere are tables created in Postgres:\r\n```\r\ncayley=# \\d\r\n                List of relations\r\n Schema |       Name        |   Type   |  Owner\r\n--------+-------------------+----------+----------\r\n public | nodes             | table    | postgres\r\n public | quads             | table    | postgres\r\n public | quads_horizon_seq | sequence | postgres\r\n(3 rows)\r\n```"},"comment":{"url":"https://api.github.com/repos/cayleygraph/cayley/issues/comments/248582585","html_url":"https://github.com/cayleygraph/cayley/issues/478#issuecomment-248582585","issue_url":"https://api.github.com/repos/cayleygraph/cayley/issues/478","id":248582585,"user":{"login":"maximmi","id":1146619,"avatar_url":"https://avatars.githubusercontent.com/u/1146619?v=3","gravatar_id":"","url":"https://api.github.com/users/maximmi","html_url":"https://github.com/maximmi","followers_url":"https://api.github.com/users/maximmi/followers","following_url":"https://api.github.com/users/maximmi/following{/other_user}","gists_url":"https://api.github.com/users/maximmi/gists{/gist_id}","starred_url":"https://api.github.com/users/maximmi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maximmi/subscriptions","organizations_url":"https://api.github.com/users/maximmi/orgs","repos_url":"https://api.github.com/users/maximmi/repos","events_url":"https://api.github.com/users/maximmi/events{/privacy}","received_events_url":"https://api.github.com/users/maximmi/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T11:20:49Z","updated_at":"2016-09-21T11:20:49Z","body":"I am using latest build from sources for cayley and 9.4.5 build of Postgres"}}
{"actor":{"display_login":"maximmi"}}