pgRouting fails to load correctly

[darkblueb]

attempted a patch with legacy.sql in rev9820 however, database pgrouting, table ways shows NULL values in all source and target columns. Exercising the quickstart call shortest_path() fails.

[darkblueb]

/var/log/postgresql/postgresql-9.1-main.log shows many failures even with legacy.sql loaded, because of a missing type geoms

[hamish]

I believe the "missing geoms type" is perhaps from the original attempt without legacy.sql. try flushing the log before dropping and recreating the db, or using tail to pull out just the latest attempt.

continued in #1089 ...

Hamish

ps- if you open or comment to a ticket you are automatically added to the cc list. also, you can use your osgeo id instead of your email address to avoid the spam harvesting robots from seeing it.