{"action":"created","issue":{"url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/18","repository_url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate","labels_url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/18/comments","events_url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/18/events","html_url":"https://github.com/miguelgrinberg/Flask-Migrate/issues/18","id":28765995,"number":18,"title":"upgrade tries to drop native PostGIS tables","user":{"login":"mvexel","id":120452,"avatar_url":"https://avatars.githubusercontent.com/u/120452?v=3","gravatar_id":"","url":"https://api.github.com/users/mvexel","html_url":"https://github.com/mvexel","followers_url":"https://api.github.com/users/mvexel/followers","following_url":"https://api.github.com/users/mvexel/following{/other_user}","gists_url":"https://api.github.com/users/mvexel/gists{/gist_id}","starred_url":"https://api.github.com/users/mvexel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvexel/subscriptions","organizations_url":"https://api.github.com/users/mvexel/orgs","repos_url":"https://api.github.com/users/mvexel/repos","events_url":"https://api.github.com/users/mvexel/events{/privacy}","received_events_url":"https://api.github.com/users/mvexel/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2014-03-05T05:24:38Z","updated_at":"2016-09-25T10:30:21Z","closed_at":"2014-03-05T05:33:01Z","body":"I have a PostGIS enabled PostgreSQL database I want to perform migrations on, but upon `python manage.py db upgrade` I get (last few lines):\r\n    \r\n    File \"/Users/martijnv/.virtualenvs/mr/lib/python2.7/site-packages/sqlalchemy/engine/default.py\", line 425, in do_execute\r\n    cursor.execute(statement, parameters)\r\n    sqlalchemy.exc.InternalError: (InternalError) cannot drop table spatial_ref_sys because extension postgis requires it\r\n    HINT:  You can drop extension postgis instead.\r\n    '\\nDROP TABLE spatial_ref_sys' {}\r\n\r\nNot being familiar with alembic I don't know if this is something I can make go away by manually editing the migration file, or if it's a bug in alembic, or in flask-migrate."},"comment":{"url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/comments/249414235","html_url":"https://github.com/miguelgrinberg/Flask-Migrate/issues/18#issuecomment-249414235","issue_url":"https://api.github.com/repos/miguelgrinberg/Flask-Migrate/issues/18","id":249414235,"user":{"login":"stefaang","id":974800,"avatar_url":"https://avatars.githubusercontent.com/u/974800?v=3","gravatar_id":"","url":"https://api.github.com/users/stefaang","html_url":"https://github.com/stefaang","followers_url":"https://api.github.com/users/stefaang/followers","following_url":"https://api.github.com/users/stefaang/following{/other_user}","gists_url":"https://api.github.com/users/stefaang/gists{/gist_id}","starred_url":"https://api.github.com/users/stefaang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stefaang/subscriptions","organizations_url":"https://api.github.com/users/stefaang/orgs","repos_url":"https://api.github.com/users/stefaang/repos","events_url":"https://api.github.com/users/stefaang/events{/privacy}","received_events_url":"https://api.github.com/users/stefaang/received_events","type":"User","site_admin":false},"created_at":"2016-09-25T10:30:21Z","updated_at":"2016-09-25T10:30:21Z","body":"As the link doesn't work anymore, you may use this\r\nhttps://gist.github.com/utek/6163250"}}
{"actor":{"display_login":"stefaang"}}