{"action":"created","issue":{"url":"https://api.github.com/repos/pgRouting/pgrouting/issues/372","labels_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/372/labels{/name}","comments_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/372/comments","events_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/372/events","html_url":"https://github.com/pgRouting/pgrouting/issues/372","id":96585347,"number":372,"title":"Missing Extension upgrade from 2.0.0 to 2.1.0 script","user":{"login":"woodbri","id":805250,"avatar_url":"https://avatars.githubusercontent.com/u/805250?v=3","gravatar_id":"","url":"https://api.github.com/users/woodbri","html_url":"https://github.com/woodbri","followers_url":"https://api.github.com/users/woodbri/followers","following_url":"https://api.github.com/users/woodbri/following{/other_user}","gists_url":"https://api.github.com/users/woodbri/gists{/gist_id}","starred_url":"https://api.github.com/users/woodbri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woodbri/subscriptions","organizations_url":"https://api.github.com/users/woodbri/orgs","repos_url":"https://api.github.com/users/woodbri/repos","events_url":"https://api.github.com/users/woodbri/events{/privacy}","received_events_url":"https://api.github.com/users/woodbri/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pgRouting/pgrouting/labels/Bug%20Report","name":"Bug Report","color":"e11d21"},{"url":"https://api.github.com/repos/pgRouting/pgrouting/labels/Installation","name":"Installation","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/pgRouting/pgrouting/milestones/3","html_url":"https://github.com/pgRouting/pgrouting/milestones/Release%202.1.0","labels_url":"https://api.github.com/repos/pgRouting/pgrouting/milestones/3/labels","id":333674,"number":3,"title":"Release 2.1.0","description":"Issues that are scheduled for version 2.1.0","creator":{"login":"dkastl","id":227762,"avatar_url":"https://avatars.githubusercontent.com/u/227762?v=3","gravatar_id":"","url":"https://api.github.com/users/dkastl","html_url":"https://github.com/dkastl","followers_url":"https://api.github.com/users/dkastl/followers","following_url":"https://api.github.com/users/dkastl/following{/other_user}","gists_url":"https://api.github.com/users/dkastl/gists{/gist_id}","starred_url":"https://api.github.com/users/dkastl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dkastl/subscriptions","organizations_url":"https://api.github.com/users/dkastl/orgs","repos_url":"https://api.github.com/users/dkastl/repos","events_url":"https://api.github.com/users/dkastl/events{/privacy}","received_events_url":"https://api.github.com/users/dkastl/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":60,"state":"open","created_at":"2013-05-14T16:24:11Z","updated_at":"2015-07-22T14:55:58Z","due_on":null,"closed_at":null},"comments":26,"created_at":"2015-07-22T14:44:06Z","updated_at":"2015-07-24T16:45:57Z","closed_at":null,"body":"There was a discussion on postgis about upgrading and that reminded me that we probably need a an upgrade from 2.0.0 to 2.1.0 script. For an example look at /usr/share/postgresql/9.4/extension/postgis--2.0.0--2.1.7.sql. @robe2 might be able to help with this."},"comment":{"url":"https://api.github.com/repos/pgRouting/pgrouting/issues/comments/124576487","html_url":"https://github.com/pgRouting/pgrouting/issues/372#issuecomment-124576487","issue_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/372","id":124576487,"user":{"login":"woodbri","id":805250,"avatar_url":"https://avatars.githubusercontent.com/u/805250?v=3","gravatar_id":"","url":"https://api.github.com/users/woodbri","html_url":"https://github.com/woodbri","followers_url":"https://api.github.com/users/woodbri/followers","following_url":"https://api.github.com/users/woodbri/following{/other_user}","gists_url":"https://api.github.com/users/woodbri/gists{/gist_id}","starred_url":"https://api.github.com/users/woodbri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woodbri/subscriptions","organizations_url":"https://api.github.com/users/woodbri/orgs","repos_url":"https://api.github.com/users/woodbri/repos","events_url":"https://api.github.com/users/woodbri/events{/privacy}","received_events_url":"https://api.github.com/users/woodbri/received_events","type":"User","site_admin":false},"created_at":"2015-07-24T16:45:57Z","updated_at":"2015-07-24T16:45:57Z","body":"I'm still working on these scripts and I'm changing the way things work in a major way, so not ready for testing yet. Also, test-runner.pl creates a new database with the current version of the software based on what has already been installed and it does not look at what is in the build directory. So I will have to modify or create a new script to install an old version of pgrouting and then do the update to the current version and then run the tests in that database.\r\n\r\nRegarding your test script above:\r\nyou install 2.0, checkout develop and run tests based on 2.1 which is why it fails.\r\n``tools/build-upgrade-scripts develop`` only writes a file in the build dir, it does not change install anything or modify the server. \r\n\r\nYou can partially test it like this:\r\n```\r\ngit checkout master\r\nrm -rf build\r\nmkdir build\r\ncd build\r\ncmake -DWITH_DD=YES ..\r\nmake\r\nsudo make install\r\ngit checkout develop\r\ncmake ..\r\nmake\r\nsudo make install\r\n../tools/build-upgrade-scripts develop\r\nsudo cp lib/pgrouting--2.0.0--2.1.0.sql /usr/share/postgresql/9.4/extension/\r\ncreatedb -U postgres -h localhost test_2_0_update\r\npsql -U postgres -h localhost test_2_0_update -c \"create extension pgrouting with version '2.0.0'\"\r\npsql -U postgres -h localhost test_2_0_update -c \"alter extension pgrouting update to '2.1.0'\"\r\npsql -U postgres -h localhost test_2_0_update # run some manual tests\r\n```"}}