2

I'm following anita Graser's process (https://anitagraser.com/2011/05/13/catchment-areas-with-pgrouting-driving_distance/) and I don't know how to add LANGUAGE C. When I try to execute routing_dd.sql it says Language 'C' doesn't exist. I try the command CREATE LANGUAGE 'C' but it is not supported. How can I add this language?

5

You are trying to follow instructions from 2011. They don't apply to current versions of PostGIS/PgRouting.

Instead, just do

CREATE EXTENSION Postgis;
CREATE EXTENSION pgrouting;

PgRouting should be shipped by default with current PostGIS versions.

See pgRouting 2.0 for Windows quick guide in case you are using Windows.

  • You also need to do: CREATE EXTENSION pgrouting; – LR1234567 May 22 '17 at 15:09
  • I have added the two Extensions and the column 'source' and 'target' but when I try the command pgr_createTopology(), it fails and I can't move on with the instructions Can you helpme with this? – Raúl Ignacio Aránguiz Viveros May 22 '17 at 20:44
  • @RaúlIgnacioAránguizViveros that should be a new question. Make sure to include the command you complete sql statement in the question – underdark May 24 '17 at 18:04
  • @LR1234567 Thank you! I've updated my answer – underdark May 26 '17 at 18:04
  • @underdark I have created a new question gis.stackexchange.com/questions/241761/… I hope you can help me thanks! – Raúl Ignacio Aránguiz Viveros May 27 '17 at 15:37
1

Which operating system are you using?

Try adding the language using a lower case 'c' instead - so CREATE LANGUAGE 'c' SOURCE

You may also want to look into making sure you have your dependencies installed correctly using this page.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.