{"action":"created","issue":{"url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/172","labels_url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/172/labels{/name}","comments_url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/172/comments","events_url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/172/events","html_url":"https://github.com/rgeo/activerecord-postgis-adapter/issues/172","id":67075816,"number":172,"title":"Collumn type migration when updating from 2.x to 3.x","user":{"login":"steffenix","id":2143646,"avatar_url":"https://avatars.githubusercontent.com/u/2143646?v=3","gravatar_id":"","url":"https://api.github.com/users/steffenix","html_url":"https://github.com/steffenix","followers_url":"https://api.github.com/users/steffenix/followers","following_url":"https://api.github.com/users/steffenix/following{/other_user}","gists_url":"https://api.github.com/users/steffenix/gists{/gist_id}","starred_url":"https://api.github.com/users/steffenix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steffenix/subscriptions","organizations_url":"https://api.github.com/users/steffenix/orgs","repos_url":"https://api.github.com/users/steffenix/repos","events_url":"https://api.github.com/users/steffenix/events{/privacy}","received_events_url":"https://api.github.com/users/steffenix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-08T08:22:00Z","updated_at":"2015-04-08T15:58:10Z","closed_at":null,"body":"As I have update active record to 4.2, I have to update the postgis adapter.\r\nI would like to use `st_point` instead of `point` so I've created a migration and it fails.\r\n\r\n `change_column :region_points, :lonlat, :st_point, geographic: true`\r\n\r\nI get PG::UndefinedObject: ERROR:  type \"st_point\" does not exist"},"comment":{"url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/comments/90959136","html_url":"https://github.com/rgeo/activerecord-postgis-adapter/issues/172#issuecomment-90959136","issue_url":"https://api.github.com/repos/rgeo/activerecord-postgis-adapter/issues/172","id":90959136,"user":{"login":"teeparham","id":54017,"avatar_url":"https://avatars.githubusercontent.com/u/54017?v=3","gravatar_id":"","url":"https://api.github.com/users/teeparham","html_url":"https://github.com/teeparham","followers_url":"https://api.github.com/users/teeparham/followers","following_url":"https://api.github.com/users/teeparham/following{/other_user}","gists_url":"https://api.github.com/users/teeparham/gists{/gist_id}","starred_url":"https://api.github.com/users/teeparham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teeparham/subscriptions","organizations_url":"https://api.github.com/users/teeparham/orgs","repos_url":"https://api.github.com/users/teeparham/repos","events_url":"https://api.github.com/users/teeparham/events{/privacy}","received_events_url":"https://api.github.com/users/teeparham/received_events","type":"User","site_admin":false},"created_at":"2015-04-08T15:58:10Z","updated_at":"2015-04-08T15:58:10Z","body":"You do not need to change the column type in a migration when you upgrade the adapter to 3.0 since the column type in the database is the same. Only the syntax for specifying the column type in migrations has changed. \r\n\r\nAfter upgrading the gem, run `rake db:schema:dump` to dump the schema in the new format. Your schema should be the same if you're using a SQL structure (`structure.sql`), and may be slightly different if you're using a ruby schema file (`schema.rb`)."}}