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?

2 Answers 2

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.

5
  • You also need to do: CREATE EXTENSION pgrouting;
    – Regina Obe
    Commented May 22, 2017 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? Commented May 22, 2017 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
    Commented May 24, 2017 at 18:04
  • @LR1234567 Thank you! I've updated my answer
    – underdark
    Commented May 26, 2017 at 18:04
  • @underdark I have created a new question gis.stackexchange.com/questions/241761/… I hope you can help me thanks! Commented May 27, 2017 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 and acknowledge you have read our privacy policy.

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