{"action":"created","issue":{"url":"https://api.github.com/repos/reorg/pg_repack/issues/97","repository_url":"https://api.github.com/repos/reorg/pg_repack","labels_url":"https://api.github.com/repos/reorg/pg_repack/issues/97/labels{/name}","comments_url":"https://api.github.com/repos/reorg/pg_repack/issues/97/comments","events_url":"https://api.github.com/repos/reorg/pg_repack/issues/97/events","html_url":"https://github.com/reorg/pg_repack/pull/97","id":184848295,"number":97,"title":"new option 'include-extensions' (don't touch tables that belong to extensions)","user":{"login":"funbringer","id":3599598,"avatar_url":"https://avatars.githubusercontent.com/u/3599598?v=3","gravatar_id":"","url":"https://api.github.com/users/funbringer","html_url":"https://github.com/funbringer","followers_url":"https://api.github.com/users/funbringer/followers","following_url":"https://api.github.com/users/funbringer/following{/other_user}","gists_url":"https://api.github.com/users/funbringer/gists{/gist_id}","starred_url":"https://api.github.com/users/funbringer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/funbringer/subscriptions","organizations_url":"https://api.github.com/users/funbringer/orgs","repos_url":"https://api.github.com/users/funbringer/repos","events_url":"https://api.github.com/users/funbringer/events{/privacy}","received_events_url":"https://api.github.com/users/funbringer/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-10-24T13:58:09Z","updated_at":"2016-11-11T13:33:47Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/reorg/pg_repack/pulls/97","html_url":"https://github.com/reorg/pg_repack/pull/97","diff_url":"https://github.com/reorg/pg_repack/pull/97.diff","patch_url":"https://github.com/reorg/pg_repack/pull/97.patch"},"body":"Hi guys,\n\nI'm one of the developers of [pg_pathman](https://github.com/postgrespro/pg_pathman), a new partitioning tool for PostgreSQL.\n\nRecently, one of our clients had trouble running pg_repack on a DB containing some tables partitioned by pg_pathman. In other words, pg_repack would hang _every time_ when trying to lock `pathman_config`, a table that we use to store partitioning configuration. As it turns out, when pg_repack opens a secondary connection and performs any query, our `post_parse_analyze_hook` comes into play and tries to read `pathman_config` (for planning purposes), which is impossible, hence the deadlock :(\n\nThis gave me an idea that it would be nice if we could make pg_repack forget about `pathman_config` and other tables that belong to their extensions. There might always be some code that heavily depends on such tables, so I've created a new option called `include-extensions` (which is set to false by default) to include them when it's really needed.\n\nHope this works out.\n"},"comment":{"url":"https://api.github.com/repos/reorg/pg_repack/issues/comments/259958068","html_url":"https://github.com/reorg/pg_repack/pull/97#issuecomment-259958068","issue_url":"https://api.github.com/repos/reorg/pg_repack/issues/97","id":259958068,"user":{"login":"schmiddy","id":1028135,"avatar_url":"https://avatars.githubusercontent.com/u/1028135?v=3","gravatar_id":"","url":"https://api.github.com/users/schmiddy","html_url":"https://github.com/schmiddy","followers_url":"https://api.github.com/users/schmiddy/followers","following_url":"https://api.github.com/users/schmiddy/following{/other_user}","gists_url":"https://api.github.com/users/schmiddy/gists{/gist_id}","starred_url":"https://api.github.com/users/schmiddy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schmiddy/subscriptions","organizations_url":"https://api.github.com/users/schmiddy/orgs","repos_url":"https://api.github.com/users/schmiddy/repos","events_url":"https://api.github.com/users/schmiddy/events{/privacy}","received_events_url":"https://api.github.com/users/schmiddy/received_events","type":"User","site_admin":false},"created_at":"2016-11-11T13:33:47Z","updated_at":"2016-11-11T13:33:47Z","body":"@MichaelDBA right, I like to test such changes myself before clicking merge (only reason I haven't merged yet). Our `installtest` tests today are far from adequate, I would love to have more comprehensive tests in general."}}
{"actor":{"display_login":"schmiddy"}}