1 
    CREATE OR REPLACE FUNCTION shortest_path(
                      sql text, 
                      source_id integer, 
                      target_id integer, 
                      directed boolean, 
                      has_reverse_cost boolean)
    RETURNS SETOF path_result
    AS '$libdir/librouting'
    LANGUAGE 'C' IMMUTABLE STRICT;

When I try to Create a Function like the above I am getting a error like language C Does not exist

Postgres Version 9.3 x86 PostGIS Version - postgis Bundle Version 2.1(with pgrouting 2.0)

Improve this question
3
  • Does this answer your question: stackoverflow.com/questions/12514664/…. Basically, change the C to a c and reload the function definition. Commented Oct 30, 2014 at 7:07
  • 4
    The language name is an identifier not a string value. So you should not use single quotes for it. language c should work just fine. Using single quotes to specify the language is a deprecated feature that is only supported for backwards compatibility. Commented Oct 30, 2014 at 7:39
  • yes now i figured out Commented Oct 30, 2014 at 7:39
Related questions
6
ERROR: function addgeometrycolumn is not unique
1
postgresql syntax error at or near create when creating a function
1
Creating a function. Error: syntax error at or near ";" OR Error: No language specified
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.