{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/dplyr/issues/1784","repository_url":"https://api.github.com/repos/hadley/dplyr","labels_url":"https://api.github.com/repos/hadley/dplyr/issues/1784/labels{/name}","comments_url":"https://api.github.com/repos/hadley/dplyr/issues/1784/comments","events_url":"https://api.github.com/repos/hadley/dplyr/issues/1784/events","html_url":"https://github.com/hadley/dplyr/pull/1784","id":150507469,"number":1784,"title":"Changes to work nicely with Redshift (RPostgres and optional BEGIN on copy_to)","user":{"login":"sicarul","id":4952116,"avatar_url":"https://avatars.githubusercontent.com/u/4952116?v=3","gravatar_id":"","url":"https://api.github.com/users/sicarul","html_url":"https://github.com/sicarul","followers_url":"https://api.github.com/users/sicarul/followers","following_url":"https://api.github.com/users/sicarul/following{/other_user}","gists_url":"https://api.github.com/users/sicarul/gists{/gist_id}","starred_url":"https://api.github.com/users/sicarul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sicarul/subscriptions","organizations_url":"https://api.github.com/users/sicarul/orgs","repos_url":"https://api.github.com/users/sicarul/repos","events_url":"https://api.github.com/users/sicarul/events{/privacy}","received_events_url":"https://api.github.com/users/sicarul/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2016-04-23T01:57:23Z","updated_at":"2016-05-26T16:34:41Z","closed_at":"2016-05-26T15:51:31Z","pull_request":{"url":"https://api.github.com/repos/hadley/dplyr/pulls/1784","html_url":"https://github.com/hadley/dplyr/pull/1784","diff_url":"https://github.com/hadley/dplyr/pull/1784.diff","patch_url":"https://github.com/hadley/dplyr/pull/1784.patch"},"body":"Hello, i tried to use dplyr for my Redshift database with enforced SSL, and the only R library able to connect for me is RPostgres, RPostgreSQL doesn't work for me. I understood from issues i saw that a migration to RPostgres was in order, sorry if i misinterpreted that.\r\n\r\nI changed src_postgres to use RPostgres instead of RPostgreSQL and added an additional parameter to copy_to so the BEGIN at the start of the transaction is optional. I added this because for some reason Redshift fails miserably when BEGIN is called, but works flawless otherwise.\r\n\r\nI have tried many transformations and this change seems to work fine, though i understand it may break people's code if they are using this assuming it will use the RPostgreSQL driver. If there's a better way to implement this i'll be happy to modify my code per the team's instructions, i'd like to get this upstream for because it'll probably be useful for other redshift users like myself.\r\n\r\nThanks! This R package is magical"},"comment":{"url":"https://api.github.com/repos/hadley/dplyr/issues/comments/221924887","html_url":"https://github.com/hadley/dplyr/pull/1784#issuecomment-221924887","issue_url":"https://api.github.com/repos/hadley/dplyr/issues/1784","id":221924887,"user":{"login":"sicarul","id":4952116,"avatar_url":"https://avatars.githubusercontent.com/u/4952116?v=3","gravatar_id":"","url":"https://api.github.com/users/sicarul","html_url":"https://github.com/sicarul","followers_url":"https://api.github.com/users/sicarul/followers","following_url":"https://api.github.com/users/sicarul/following{/other_user}","gists_url":"https://api.github.com/users/sicarul/gists{/gist_id}","starred_url":"https://api.github.com/users/sicarul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sicarul/subscriptions","organizations_url":"https://api.github.com/users/sicarul/orgs","repos_url":"https://api.github.com/users/sicarul/repos","events_url":"https://api.github.com/users/sicarul/events{/privacy}","received_events_url":"https://api.github.com/users/sicarul/received_events","type":"User","site_admin":false},"created_at":"2016-05-26T16:34:41Z","updated_at":"2016-05-26T16:34:41Z","body":"Ok, thanks @hadley, will look into this when i have some spare time! 👍 "}}
{"actor":{"display_login":"sicarul"}}