{"action":"created","issue":{"url":"https://api.github.com/repos/tathougies/beam/issues/241","repository_url":"https://api.github.com/repos/tathougies/beam","labels_url":"https://api.github.com/repos/tathougies/beam/issues/241/labels{/name}","comments_url":"https://api.github.com/repos/tathougies/beam/issues/241/comments","events_url":"https://api.github.com/repos/tathougies/beam/issues/241/events","html_url":"https://github.com/tathougies/beam/pull/241","id":325415122,"number":241,"title":"Ignore dropped columns in getDbConstraints","user":{"login":"mulderr","id":5698461,"avatar_url":"https://avatars2.githubusercontent.com/u/5698461?v=4","gravatar_id":"","url":"https://api.github.com/users/mulderr","html_url":"https://github.com/mulderr","followers_url":"https://api.github.com/users/mulderr/followers","following_url":"https://api.github.com/users/mulderr/following{/other_user}","gists_url":"https://api.github.com/users/mulderr/gists{/gist_id}","starred_url":"https://api.github.com/users/mulderr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mulderr/subscriptions","organizations_url":"https://api.github.com/users/mulderr/orgs","repos_url":"https://api.github.com/users/mulderr/repos","events_url":"https://api.github.com/users/mulderr/events{/privacy}","received_events_url":"https://api.github.com/users/mulderr/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-05-22T18:36:25Z","updated_at":"2018-05-23T18:55:50Z","closed_at":"2018-05-23T18:55:41Z","author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/tathougies/beam/pulls/241","html_url":"https://github.com/tathougies/beam/pull/241","diff_url":"https://github.com/tathougies/beam/pull/241.diff","patch_url":"https://github.com/tathougies/beam/pull/241.patch"},"body":"`getDbConstraints` must filter out dropped columns when gathering info for column checks. Otherwise the query could result in something like below. Tested on 9.6.8.\r\n\r\n```\r\n           attname            | atttypid | atttypmod | attnotnull |         format_type\r\n------------------------------+----------+-----------+------------+-----------------------------\r\n id                           |       20 |        -1 | t          | bigint\r\n (...)\r\n ........pg.dropped.7........ |        0 |        -1 | f          | -\r\n ........pg.dropped.8........ |        0 |        -1 | f          | -\r\n ........pg.dropped.9........ |        0 |        -1 | f          | -\r\n```"},"comment":{"url":"https://api.github.com/repos/tathougies/beam/issues/comments/391458982","html_url":"https://github.com/tathougies/beam/pull/241#issuecomment-391458982","issue_url":"https://api.github.com/repos/tathougies/beam/issues/241","id":391458982,"user":{"login":"tathougies","id":321522,"avatar_url":"https://avatars0.githubusercontent.com/u/321522?v=4","gravatar_id":"","url":"https://api.github.com/users/tathougies","html_url":"https://github.com/tathougies","followers_url":"https://api.github.com/users/tathougies/followers","following_url":"https://api.github.com/users/tathougies/following{/other_user}","gists_url":"https://api.github.com/users/tathougies/gists{/gist_id}","starred_url":"https://api.github.com/users/tathougies/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tathougies/subscriptions","organizations_url":"https://api.github.com/users/tathougies/orgs","repos_url":"https://api.github.com/users/tathougies/repos","events_url":"https://api.github.com/users/tathougies/events{/privacy}","received_events_url":"https://api.github.com/users/tathougies/received_events","type":"User","site_admin":false},"created_at":"2018-05-23T18:55:50Z","updated_at":"2018-05-23T18:55:50Z","author_association":"OWNER","body":"Nice catch!"}}
{"actor":{"display_login":"tathougies"}}