{"action":"created","issue":{"url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/63","repository_url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift","labels_url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/63/comments","events_url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/63/events","html_url":"https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/63","id":114278407,"number":63,"title":"Autocommit when executing a COPY command","user":{"login":"berdario","id":752835,"avatar_url":"https://avatars.githubusercontent.com/u/752835?v=3","gravatar_id":"","url":"https://api.github.com/users/berdario","html_url":"https://github.com/berdario","followers_url":"https://api.github.com/users/berdario/followers","following_url":"https://api.github.com/users/berdario/following{/other_user}","gists_url":"https://api.github.com/users/berdario/gists{/gist_id}","starred_url":"https://api.github.com/users/berdario/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/berdario/subscriptions","organizations_url":"https://api.github.com/users/berdario/orgs","repos_url":"https://api.github.com/users/berdario/repos","events_url":"https://api.github.com/users/berdario/events{/privacy}","received_events_url":"https://api.github.com/users/berdario/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":16,"created_at":"2015-10-30T14:16:33Z","updated_at":"2016-05-08T10:01:42Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/pulls/63","html_url":"https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/63","diff_url":"https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/63.diff","patch_url":"https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/63.patch"},"body":"This would help with this issue, I think:\r\n\r\nhttp://stackoverflow.com/questions/28271049/redshift-copy-operation-doesnt-work-in-sqlalchemy#\r\n\r\nI'm still new with Redshift, and I haven't checked if there are any Redshift-specific commands aside from `COPY` (which is the only one that I've used as for now)"},"comment":{"url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/comments/217707137","html_url":"https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/63#issuecomment-217707137","issue_url":"https://api.github.com/repos/sqlalchemy-redshift/sqlalchemy-redshift/issues/63","id":217707137,"user":{"login":"mtrbean","id":222778,"avatar_url":"https://avatars.githubusercontent.com/u/222778?v=3","gravatar_id":"","url":"https://api.github.com/users/mtrbean","html_url":"https://github.com/mtrbean","followers_url":"https://api.github.com/users/mtrbean/followers","following_url":"https://api.github.com/users/mtrbean/following{/other_user}","gists_url":"https://api.github.com/users/mtrbean/gists{/gist_id}","starred_url":"https://api.github.com/users/mtrbean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtrbean/subscriptions","organizations_url":"https://api.github.com/users/mtrbean/orgs","repos_url":"https://api.github.com/users/mtrbean/repos","events_url":"https://api.github.com/users/mtrbean/events{/privacy}","received_events_url":"https://api.github.com/users/mtrbean/received_events","type":"User","site_admin":false},"created_at":"2016-05-08T10:01:42Z","updated_at":"2016-05-08T10:01:42Z","body":"I feel strongly against hard-wiring autocommit to COPY commands because it looks like we are losing the ability to rollback a transaction that contains a COPY statement. Thoughts?"}}