{"action":"created","issue":{"url":"https://api.github.com/repos/slick/slick/issues/1631","repository_url":"https://api.github.com/repos/slick/slick","labels_url":"https://api.github.com/repos/slick/slick/issues/1631/labels{/name}","comments_url":"https://api.github.com/repos/slick/slick/issues/1631/comments","events_url":"https://api.github.com/repos/slick/slick/issues/1631/events","html_url":"https://github.com/slick/slick/pull/1631","id":184555451,"number":1631,"title":"Upsert in Postgres is natively supported in 9.5 & 9.6","user":{"login":"nremond","id":600102,"avatar_url":"https://avatars.githubusercontent.com/u/600102?v=3","gravatar_id":"","url":"https://api.github.com/users/nremond","html_url":"https://github.com/nremond","followers_url":"https://api.github.com/users/nremond/followers","following_url":"https://api.github.com/users/nremond/following{/other_user}","gists_url":"https://api.github.com/users/nremond/gists{/gist_id}","starred_url":"https://api.github.com/users/nremond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nremond/subscriptions","organizations_url":"https://api.github.com/users/nremond/orgs","repos_url":"https://api.github.com/users/nremond/repos","events_url":"https://api.github.com/users/nremond/events{/privacy}","received_events_url":"https://api.github.com/users/nremond/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/slick/slick/labels/improvement","name":"improvement","color":"009800"}],"state":"open","locked":false,"assignee":{"login":"tminglei","id":1828949,"avatar_url":"https://avatars.githubusercontent.com/u/1828949?v=3","gravatar_id":"","url":"https://api.github.com/users/tminglei","html_url":"https://github.com/tminglei","followers_url":"https://api.github.com/users/tminglei/followers","following_url":"https://api.github.com/users/tminglei/following{/other_user}","gists_url":"https://api.github.com/users/tminglei/gists{/gist_id}","starred_url":"https://api.github.com/users/tminglei/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tminglei/subscriptions","organizations_url":"https://api.github.com/users/tminglei/orgs","repos_url":"https://api.github.com/users/tminglei/repos","events_url":"https://api.github.com/users/tminglei/events{/privacy}","received_events_url":"https://api.github.com/users/tminglei/received_events","type":"User","site_admin":false},"assignees":[{"login":"tminglei","id":1828949,"avatar_url":"https://avatars.githubusercontent.com/u/1828949?v=3","gravatar_id":"","url":"https://api.github.com/users/tminglei","html_url":"https://github.com/tminglei","followers_url":"https://api.github.com/users/tminglei/followers","following_url":"https://api.github.com/users/tminglei/following{/other_user}","gists_url":"https://api.github.com/users/tminglei/gists{/gist_id}","starred_url":"https://api.github.com/users/tminglei/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tminglei/subscriptions","organizations_url":"https://api.github.com/users/tminglei/orgs","repos_url":"https://api.github.com/users/tminglei/repos","events_url":"https://api.github.com/users/tminglei/events{/privacy}","received_events_url":"https://api.github.com/users/tminglei/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/slick/slick/milestones/20","html_url":"https://github.com/slick/slick/milestones/3.2.0","labels_url":"https://api.github.com/repos/slick/slick/milestones/20/labels","id":1269007,"number":20,"title":"3.2.0","description":"","creator":{"login":"szeiger","id":54262,"avatar_url":"https://avatars.githubusercontent.com/u/54262?v=3","gravatar_id":"","url":"https://api.github.com/users/szeiger","html_url":"https://github.com/szeiger","followers_url":"https://api.github.com/users/szeiger/followers","following_url":"https://api.github.com/users/szeiger/following{/other_user}","gists_url":"https://api.github.com/users/szeiger/gists{/gist_id}","starred_url":"https://api.github.com/users/szeiger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szeiger/subscriptions","organizations_url":"https://api.github.com/users/szeiger/orgs","repos_url":"https://api.github.com/users/szeiger/repos","events_url":"https://api.github.com/users/szeiger/events{/privacy}","received_events_url":"https://api.github.com/users/szeiger/received_events","type":"User","site_admin":false},"open_issues":121,"closed_issues":22,"state":"open","created_at":"2015-08-24T09:02:58Z","updated_at":"2016-10-24T13:29:02Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2016-10-21T19:52:56Z","updated_at":"2016-10-24T13:47:22Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/slick/slick/pulls/1631","html_url":"https://github.com/slick/slick/pull/1631","diff_url":"https://github.com/slick/slick/pull/1631.diff","patch_url":"https://github.com/slick/slick/pull/1631.patch"},"body":"Hi,\r\n\r\nThe two last versions of Postgresql natively support upsert query, cf: (https://www.postgresql.org/docs/9.5/static/sql-insert.html#SQL-ON-CONFLICT)\r\n\r\nI haven't found the associated test and how to run tests on the Postgres database, could someone help me with that?\r\n\r\nSo, just starting the discussion ..."},"comment":{"url":"https://api.github.com/repos/slick/slick/issues/comments/255744885","html_url":"https://github.com/slick/slick/pull/1631#issuecomment-255744885","issue_url":"https://api.github.com/repos/slick/slick/issues/1631","id":255744885,"user":{"login":"nremond","id":600102,"avatar_url":"https://avatars.githubusercontent.com/u/600102?v=3","gravatar_id":"","url":"https://api.github.com/users/nremond","html_url":"https://github.com/nremond","followers_url":"https://api.github.com/users/nremond/followers","following_url":"https://api.github.com/users/nremond/following{/other_user}","gists_url":"https://api.github.com/users/nremond/gists{/gist_id}","starred_url":"https://api.github.com/users/nremond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nremond/subscriptions","organizations_url":"https://api.github.com/users/nremond/orgs","repos_url":"https://api.github.com/users/nremond/repos","events_url":"https://api.github.com/users/nremond/events{/privacy}","received_events_url":"https://api.github.com/users/nremond/received_events","type":"User","site_admin":false},"created_at":"2016-10-24T13:47:22Z","updated_at":"2016-10-24T13:47:22Z","body":"> \"UPSERT\" is a DBMS feature that allows a DML statement's author to atomically either insert a row, or on the basis of the row already existing, UPDATE that existing row instead, while safely giving little to no further thought to concurrency.\r\nhttps://wiki.postgresql.org/wiki/UPSERT#.22UPSERT.22_definition\r\n\r\nSo, @cvogt, the difference is that Slick's version is *not atomic*. I would personally not even call it upsert as it's very misleading. "}}
{"actor":{"display_login":"nremond"}}