Opened 7 years ago

Closed 7 years ago

#1094 closed defect (duplicate)

pgRouting fails to load correctly

Reported by: darkblueb Owned by: darkblueb
Priority: major Milestone: OSGeoLive6.5
Component: OSGeoLive Keywords: postgis
Cc: maplabs@…

Description

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.

Change history (2)

comment:1 Changed 7 years ago by darkblueb

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

comment:2 Changed 7 years ago by hamish

Resolution: duplicate
Status: newclosed

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.

Note: See TracTickets for help on using tickets.