{"action":"created","issue":{"url":"https://api.github.com/repos/flyway/flyway/issues/918","labels_url":"https://api.github.com/repos/flyway/flyway/issues/918/labels{/name}","comments_url":"https://api.github.com/repos/flyway/flyway/issues/918/comments","events_url":"https://api.github.com/repos/flyway/flyway/issues/918/events","html_url":"https://github.com/flyway/flyway/issues/918","id":53617737,"number":918,"title":"Explicitly drop Views then doing a Flyway.clean() on a PostgreSQL db","user":{"login":"gergelyszakacs","id":5073203,"avatar_url":"https://avatars.githubusercontent.com/u/5073203?v=3","gravatar_id":"","url":"https://api.github.com/users/gergelyszakacs","html_url":"https://github.com/gergelyszakacs","followers_url":"https://api.github.com/users/gergelyszakacs/followers","following_url":"https://api.github.com/users/gergelyszakacs/following{/other_user}","gists_url":"https://api.github.com/users/gergelyszakacs/gists{/gist_id}","starred_url":"https://api.github.com/users/gergelyszakacs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gergelyszakacs/subscriptions","organizations_url":"https://api.github.com/users/gergelyszakacs/orgs","repos_url":"https://api.github.com/users/gergelyszakacs/repos","events_url":"https://api.github.com/users/gergelyszakacs/events{/privacy}","received_events_url":"https://api.github.com/users/gergelyszakacs/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/flyway/flyway/labels/c:%20clean()","name":"c: clean()","color":"347484"},{"url":"https://api.github.com/repos/flyway/flyway/labels/d:%20PostgreSQL","name":"d: PostgreSQL","color":"207de5"},{"url":"https://api.github.com/repos/flyway/flyway/labels/m:%20Core","name":"m: Core","color":"fad8c7"},{"url":"https://api.github.com/repos/flyway/flyway/labels/t:%20bug","name":"t: bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/flyway/flyway/milestones/6","html_url":"https://github.com/flyway/flyway/milestones/Flyway%203.2","labels_url":"https://api.github.com/repos/flyway/flyway/milestones/6/labels","id":416157,"number":6,"title":"Flyway 3.2","description":"","creator":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":37,"state":"closed","created_at":"2013-08-31T11:09:52Z","updated_at":"2015-10-07T11:27:21Z","due_on":"2015-02-27T23:00:00Z","closed_at":"2015-03-20T22:50:10Z"},"comments":5,"created_at":"2015-01-07T10:24:14Z","updated_at":"2015-11-12T12:54:01Z","closed_at":"2015-03-05T13:55:56Z","body":"Database Views are not dropped when a Flyway.clean() is issued. If the migration scripts baseline the database with some existing tables that cannot be touched and just adds some Views (probably in a different schema than the tables themselves) then the clean() call will leave those Views in place. So a new feature is needed that explicitly drops these Views."},"comment":{"url":"https://api.github.com/repos/flyway/flyway/issues/comments/156095951","html_url":"https://github.com/flyway/flyway/issues/918#issuecomment-156095951","issue_url":"https://api.github.com/repos/flyway/flyway/issues/918","id":156095951,"user":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"created_at":"2015-11-12T12:54:01Z","updated_at":"2015-11-12T12:54:01Z","body":"@teicher Please file a new issue and include a script that Flyway fails to clean."}}