{"action":"closed","number":154,"pull_request":{"url":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154","id":15645064,"html_url":"https://github.com/SchemaPlus/schema_plus/pull/154","diff_url":"https://github.com/SchemaPlus/schema_plus/pull/154.diff","patch_url":"https://github.com/SchemaPlus/schema_plus/pull/154.patch","issue_url":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/154","number":154,"state":"closed","locked":false,"title":"Basic support for PostgreSQL materialized views","user":{"login":"redstar417","id":1307671,"avatar_url":"https://avatars.githubusercontent.com/u/1307671?v=3","gravatar_id":"","url":"https://api.github.com/users/redstar417","html_url":"https://github.com/redstar417","followers_url":"https://api.github.com/users/redstar417/followers","following_url":"https://api.github.com/users/redstar417/following{/other_user}","gists_url":"https://api.github.com/users/redstar417/gists{/gist_id}","starred_url":"https://api.github.com/users/redstar417/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/redstar417/subscriptions","organizations_url":"https://api.github.com/users/redstar417/orgs","repos_url":"https://api.github.com/users/redstar417/repos","events_url":"https://api.github.com/users/redstar417/events{/privacy}","received_events_url":"https://api.github.com/users/redstar417/received_events","type":"User","site_admin":false},"body":"Can specify that created views should be materialized. Schema is updated accordingly. Also indices on materialized views are exported to the schema.\r\n","created_at":"2014-05-08T11:34:00Z","updated_at":"2015-08-06T16:22:31Z","closed_at":"2015-08-06T16:22:31Z","merged_at":null,"merge_commit_sha":"9835b8f4ea851daf25c4ce4e2222efc83b451599","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154/commits","review_comments_url":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154/comments","review_comment_url":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/comments{/number}","comments_url":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/154/comments","statuses_url":"https://api.github.com/repos/SchemaPlus/schema_plus/statuses/1e398b0b251e2778ef2af34117f690af51996085","head":{"label":"ProactiveHealth:master","ref":"master","sha":"1e398b0b251e2778ef2af34117f690af51996085","user":{"login":"ProactiveHealth","id":6670035,"avatar_url":"https://avatars.githubusercontent.com/u/6670035?v=3","gravatar_id":"","url":"https://api.github.com/users/ProactiveHealth","html_url":"https://github.com/ProactiveHealth","followers_url":"https://api.github.com/users/ProactiveHealth/followers","following_url":"https://api.github.com/users/ProactiveHealth/following{/other_user}","gists_url":"https://api.github.com/users/ProactiveHealth/gists{/gist_id}","starred_url":"https://api.github.com/users/ProactiveHealth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ProactiveHealth/subscriptions","organizations_url":"https://api.github.com/users/ProactiveHealth/orgs","repos_url":"https://api.github.com/users/ProactiveHealth/repos","events_url":"https://api.github.com/users/ProactiveHealth/events{/privacy}","received_events_url":"https://api.github.com/users/ProactiveHealth/received_events","type":"Organization","site_admin":false},"repo":{"id":19452639,"name":"schema_plus","full_name":"ProactiveHealth/schema_plus","owner":{"login":"ProactiveHealth","id":6670035,"avatar_url":"https://avatars.githubusercontent.com/u/6670035?v=3","gravatar_id":"","url":"https://api.github.com/users/ProactiveHealth","html_url":"https://github.com/ProactiveHealth","followers_url":"https://api.github.com/users/ProactiveHealth/followers","following_url":"https://api.github.com/users/ProactiveHealth/following{/other_user}","gists_url":"https://api.github.com/users/ProactiveHealth/gists{/gist_id}","starred_url":"https://api.github.com/users/ProactiveHealth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ProactiveHealth/subscriptions","organizations_url":"https://api.github.com/users/ProactiveHealth/orgs","repos_url":"https://api.github.com/users/ProactiveHealth/repos","events_url":"https://api.github.com/users/ProactiveHealth/events{/privacy}","received_events_url":"https://api.github.com/users/ProactiveHealth/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ProactiveHealth/schema_plus","description":"SchemaPlus provides ActiveRecord support for  foreign keys, database defined validations and associations.","fork":true,"url":"https://api.github.com/repos/ProactiveHealth/schema_plus","forks_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/forks","keys_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/teams","hooks_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/hooks","issue_events_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/issues/events{/number}","events_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/events","assignees_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/assignees{/user}","branches_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/branches{/branch}","tags_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/tags","blobs_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/git/refs{/sha}","trees_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/statuses/{sha}","languages_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/languages","stargazers_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/stargazers","contributors_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/contributors","subscribers_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/subscribers","subscription_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/subscription","commits_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/commits{/sha}","git_commits_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/git/commits{/sha}","comments_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/comments{/number}","issue_comment_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/issues/comments{/number}","contents_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/contents/{+path}","compare_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/merges","archive_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/downloads","issues_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/issues{/number}","pulls_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/pulls{/number}","milestones_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/milestones{/number}","notifications_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/labels{/name}","releases_url":"https://api.github.com/repos/ProactiveHealth/schema_plus/releases{/id}","created_at":"2014-05-05T10:43:53Z","updated_at":"2014-05-08T11:34:00Z","pushed_at":"2014-05-07T11:48:43Z","git_url":"git://github.com/ProactiveHealth/schema_plus.git","ssh_url":"git@github.com:ProactiveHealth/schema_plus.git","clone_url":"https://github.com/ProactiveHealth/schema_plus.git","svn_url":"https://github.com/ProactiveHealth/schema_plus","homepage":"","size":1212,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"SchemaPlus:master","ref":"master","sha":"d214654f0901e8883bab93e15982d1a7dc57cf0c","user":{"login":"SchemaPlus","id":614848,"avatar_url":"https://avatars.githubusercontent.com/u/614848?v=3","gravatar_id":"","url":"https://api.github.com/users/SchemaPlus","html_url":"https://github.com/SchemaPlus","followers_url":"https://api.github.com/users/SchemaPlus/followers","following_url":"https://api.github.com/users/SchemaPlus/following{/other_user}","gists_url":"https://api.github.com/users/SchemaPlus/gists{/gist_id}","starred_url":"https://api.github.com/users/SchemaPlus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SchemaPlus/subscriptions","organizations_url":"https://api.github.com/users/SchemaPlus/orgs","repos_url":"https://api.github.com/users/SchemaPlus/repos","events_url":"https://api.github.com/users/SchemaPlus/events{/privacy}","received_events_url":"https://api.github.com/users/SchemaPlus/received_events","type":"Organization","site_admin":false},"repo":{"id":1359757,"name":"schema_plus","full_name":"SchemaPlus/schema_plus","owner":{"login":"SchemaPlus","id":614848,"avatar_url":"https://avatars.githubusercontent.com/u/614848?v=3","gravatar_id":"","url":"https://api.github.com/users/SchemaPlus","html_url":"https://github.com/SchemaPlus","followers_url":"https://api.github.com/users/SchemaPlus/followers","following_url":"https://api.github.com/users/SchemaPlus/following{/other_user}","gists_url":"https://api.github.com/users/SchemaPlus/gists{/gist_id}","starred_url":"https://api.github.com/users/SchemaPlus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SchemaPlus/subscriptions","organizations_url":"https://api.github.com/users/SchemaPlus/orgs","repos_url":"https://api.github.com/users/SchemaPlus/repos","events_url":"https://api.github.com/users/SchemaPlus/events{/privacy}","received_events_url":"https://api.github.com/users/SchemaPlus/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SchemaPlus/schema_plus","description":"SchemaPlus provides a collection of enhancements and extensions to ActiveRecord","fork":false,"url":"https://api.github.com/repos/SchemaPlus/schema_plus","forks_url":"https://api.github.com/repos/SchemaPlus/schema_plus/forks","keys_url":"https://api.github.com/repos/SchemaPlus/schema_plus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SchemaPlus/schema_plus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SchemaPlus/schema_plus/teams","hooks_url":"https://api.github.com/repos/SchemaPlus/schema_plus/hooks","issue_events_url":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/events{/number}","events_url":"https://api.github.com/repos/SchemaPlus/schema_plus/events","assignees_url":"https://api.github.com/repos/SchemaPlus/schema_plus/assignees{/user}","branches_url":"https://api.github.com/repos/SchemaPlus/schema_plus/branches{/branch}","tags_url":"https://api.github.com/repos/SchemaPlus/schema_plus/tags","blobs_url":"https://api.github.com/repos/SchemaPlus/schema_plus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SchemaPlus/schema_plus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SchemaPlus/schema_plus/git/refs{/sha}","trees_url":"https://api.github.com/repos/SchemaPlus/schema_plus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SchemaPlus/schema_plus/statuses/{sha}","languages_url":"https://api.github.com/repos/SchemaPlus/schema_plus/languages","stargazers_url":"https://api.github.com/repos/SchemaPlus/schema_plus/stargazers","contributors_url":"https://api.github.com/repos/SchemaPlus/schema_plus/contributors","subscribers_url":"https://api.github.com/repos/SchemaPlus/schema_plus/subscribers","subscription_url":"https://api.github.com/repos/SchemaPlus/schema_plus/subscription","commits_url":"https://api.github.com/repos/SchemaPlus/schema_plus/commits{/sha}","git_commits_url":"https://api.github.com/repos/SchemaPlus/schema_plus/git/commits{/sha}","comments_url":"https://api.github.com/repos/SchemaPlus/schema_plus/comments{/number}","issue_comment_url":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/comments{/number}","contents_url":"https://api.github.com/repos/SchemaPlus/schema_plus/contents/{+path}","compare_url":"https://api.github.com/repos/SchemaPlus/schema_plus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SchemaPlus/schema_plus/merges","archive_url":"https://api.github.com/repos/SchemaPlus/schema_plus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SchemaPlus/schema_plus/downloads","issues_url":"https://api.github.com/repos/SchemaPlus/schema_plus/issues{/number}","pulls_url":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls{/number}","milestones_url":"https://api.github.com/repos/SchemaPlus/schema_plus/milestones{/number}","notifications_url":"https://api.github.com/repos/SchemaPlus/schema_plus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SchemaPlus/schema_plus/labels{/name}","releases_url":"https://api.github.com/repos/SchemaPlus/schema_plus/releases{/id}","created_at":"2011-02-12T20:32:04Z","updated_at":"2015-08-01T20:43:17Z","pushed_at":"2015-07-25T10:26:52Z","git_url":"git://github.com/SchemaPlus/schema_plus.git","ssh_url":"git@github.com:SchemaPlus/schema_plus.git","clone_url":"https://github.com/SchemaPlus/schema_plus.git","svn_url":"https://github.com/SchemaPlus/schema_plus","homepage":"","size":2941,"stargazers_count":552,"watchers_count":552,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":78,"mirror_url":null,"open_issues_count":34,"forks":78,"open_issues":34,"watchers":552,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154"},"html":{"href":"https://github.com/SchemaPlus/schema_plus/pull/154"},"issue":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/154"},"comments":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/issues/154/comments"},"review_comments":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154/comments"},"review_comment":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/pulls/154/commits"},"statuses":{"href":"https://api.github.com/repos/SchemaPlus/schema_plus/statuses/1e398b0b251e2778ef2af34117f690af51996085"}},"merged":false,"mergeable":false,"mergeable_state":"dirty","merged_by":null,"comments":6,"review_comments":0,"commits":4,"additions":41,"deletions":7,"changed_files":5}}