{"action":"created","issue":{"url":"https://api.github.com/repos/theory/sqitch/issues/282","repository_url":"https://api.github.com/repos/theory/sqitch","labels_url":"https://api.github.com/repos/theory/sqitch/issues/282/labels{/name}","comments_url":"https://api.github.com/repos/theory/sqitch/issues/282/comments","events_url":"https://api.github.com/repos/theory/sqitch/issues/282/events","html_url":"https://github.com/theory/sqitch/issues/282","id":129637893,"number":282,"title":"Altering Table with \"rework\"","user":{"login":"dacodekid","id":10047844,"avatar_url":"https://avatars.githubusercontent.com/u/10047844?v=3","gravatar_id":"","url":"https://api.github.com/users/dacodekid","html_url":"https://github.com/dacodekid","followers_url":"https://api.github.com/users/dacodekid/followers","following_url":"https://api.github.com/users/dacodekid/following{/other_user}","gists_url":"https://api.github.com/users/dacodekid/gists{/gist_id}","starred_url":"https://api.github.com/users/dacodekid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dacodekid/subscriptions","organizations_url":"https://api.github.com/users/dacodekid/orgs","repos_url":"https://api.github.com/users/dacodekid/repos","events_url":"https://api.github.com/users/dacodekid/events{/privacy}","received_events_url":"https://api.github.com/users/dacodekid/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-01-29T01:45:04Z","updated_at":"2016-11-23T16:30:26Z","closed_at":"2016-01-29T17:02:26Z","body":"I've tried several times to follow the 'postgres tutorial', just except instead of altering a function, I'm changing a field name in table. But it ends up with same error.\n\n```\n╰─$ sqitch verify\nVerifying sqtest_db\n  * appschema .... ok\n  * contact ...... ok\nUndeployed change:\n  * contact\nVerify successful\n╭─dacodekid@mbp  ~/dev/sqtest\n╰─$ sqitch deploy\nDeploying changes to sqtest_db\n  + contact .. psql:deploy/contact.sql:10: ERROR:  relation \"contact\" already exists\nnot ok\n\"/usr/local/bin/psql\" unexpectedly returned exit value 3\n\nDeploy failed\n```\n\nThis is my before `tagged` and after `tagged` deploy query\n\nBEFORE\n\n``` sql\nBEGIN;\nCREATE TABLE sq_schema.contact\n  (\n    log_date DATE NOT NULL,\n    emp_name CHARACTER VARYING(100) DEFAULT ''\n  );\nCOMMIT;\n```\n\nAFTER\n\n``` sql\nBEGIN;\n\nCREATE TABLE sq_schema.contact\n  (\n    log_date DATE NOT NULL,\n    employee_name CHARACTER VARYING(100) DEFAULT ''\n  );\n\nCOMMIT;\n```\n"},"comment":{"url":"https://api.github.com/repos/theory/sqitch/issues/comments/262564339","html_url":"https://github.com/theory/sqitch/issues/282#issuecomment-262564339","issue_url":"https://api.github.com/repos/theory/sqitch/issues/282","id":262564339,"user":{"login":"winduptoy","id":270504,"avatar_url":"https://avatars.githubusercontent.com/u/270504?v=3","gravatar_id":"","url":"https://api.github.com/users/winduptoy","html_url":"https://github.com/winduptoy","followers_url":"https://api.github.com/users/winduptoy/followers","following_url":"https://api.github.com/users/winduptoy/following{/other_user}","gists_url":"https://api.github.com/users/winduptoy/gists{/gist_id}","starred_url":"https://api.github.com/users/winduptoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/winduptoy/subscriptions","organizations_url":"https://api.github.com/users/winduptoy/orgs","repos_url":"https://api.github.com/users/winduptoy/repos","events_url":"https://api.github.com/users/winduptoy/events{/privacy}","received_events_url":"https://api.github.com/users/winduptoy/received_events","type":"User","site_admin":false},"created_at":"2016-11-23T16:30:26Z","updated_at":"2016-11-23T16:30:26Z","body":"@theory Thank you so much for all of this. I too had this question after reading the tutorial. Might be useful to specifically call this out."}}
{"actor":{"display_login":"winduptoy"}}